I have a free hosted site and now I ALSO have a paid site. Both at freenukehosting and actually the same server/IP address. But different accounts.

I use the free site as a testing site. At the moment, I'm testing a phpBB forum. I feel satisfied with the forum and would like to copy the forum and upload it to the new paid hosted site.

I tried to download the whole directory with all the phpBB-files for the forum and then uploaded it to the new site via FTP.

How do I move the mySQL databases from the test site, to the new paid site?

Is it possible to restore the whole forum at the new site or do I really have to start from scratch?

Regards,
Davidw

1.First, you download whole phpbb directory from old serevr and up load it to new ones.
2.Then you Log in to phpmyadmin (old server) and click to your phpbb database name (ex: name_phpbb) and click to "export" button . Select all field and save as a .sql file.
3.finally, you log in to phpmyadmin(new server) and creat a database name like your old db (Ex: name_phpbb) . Click to 'SQL" button and browse to your sql file.
Done!

You will save me an hour's work... Fantastic.

Thanks!

I will try it soon! Actually I did your item one, but the copied phpBB files kept calling the test site files. Please note that the new and old sites are both on the same machine/IP at freenukehosting, but on different virtual servers/sites/accounts. I got worried that the sql files were stored in a central area for all accounts (where ARE the SQL files stored??) and that the phpBB files coding, pointed to the testsite, instead of the new site.

If you have some information about the above, then I'd really like to hear about it!

Best Regards,
Davidw

Don't worry!
If you finish upload your phpbb files to your new server , you must sure that you know about your sql username and sql database name in your new server. If it empty, log in to Control panel to make it!
When you have an sql username and sql database name (ex: sqluser: david_phpbb, sqldatabase: david_phpbb), go to your phpmyadmin and make these steps above.
In your phpbbfiles. open config.php and correct these information about sql databse and sql username (with passwords) with new ones.
Sorry about my bad English!

Hi again!
Your English is fine!

I tried to do what you said, but when I try to upload the SQL file, I get these errors in phpmyadmin:
---
SQL-query:

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 25, 2004 at 03:53 AM
-- Server version: 4.0.22
-- PHP Version: 4.3.9
--
-- Database: `davidw1_phpbb1`
--
-- --------------------------------------------------------
--
-- Table structure for table `phpbb_attach_quota`
--
DROP TABLE IF EXISTS `phpbb_attach_quota` ;

CREATE TABLE IF NOT EXISTS `phpbb_attach_quota` (
`user_id` mediumint( 8 ) unsigned NOT NULL default '0',
`group_id` mediumint( 8 ) unsigned NOT NULL default '0',
`quota_type` smallint( 2 ) NOT NULL default '0',
`quota_limit_id` mediumint( 8 ) unsigned NOT NULL default '0',
KEY `quota_type` ( `quota_type` )
) TYPE = MYISAM

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'user_id` mediumint( 8) unsigned NOT NULL default '0',
`group_i
---

Do you have any advise???

Please note that when I am in the Export screen in phpmyadmin, there are many options and I am a little unsure of what I should choose... I do not know if the above errors have any relationship to these options settings. Here is what I selected as options:
---
SQL options
Add custom comment into header (n splits lines): <nothing>
Enclose export in a transaction: <nothing>
Disable foreign key checks: <nothing>
Structure:
Add DROP TABLE: <YES>
Add IF NOT EXISTS: <YES>
Add AUTO_INCREMENT value: <YES>
Enclose table and field names with backquotes: <YES>
Add into comments
Creation/Update/Check dates: <NO>
Data:
Complete inserts: <YES>
Extended inserts: <YES>
Use delayed inserts: <YES>
Use ignore inserts: <YES>
Use hexadecimal for binary fields: <YES>
Export type: <REPLACE>
---
Also note that I, just to be sure, used gzip, to be sure nothing is changed regarding line breaks.

Regards,
davidw

I tried another way to export and restore the phpBB SQL database, by using cPanel's backup and restore feature (NOT via phpMyAdmin). This seems to work and when I go into phpMyAdmin to see if all 37 tables are there, they look good... BUT:

When I try to log in to my phpBB site, I get the following error and I don't see any phpBB pages:
---
Warning: mysql_connect(): Access denied for user: 'davidw_phpbb1@localhost' (Using password: YES) in /home/davidw/public_html/circus/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/davidw/public_html/circus/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/davidw/public_html/circus/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database
---
I think that this is a password error. The two phpBB sites (original and backup) have different usernames; mySQL will only make usernames that have the site-admin-user-for-cPanel as the prefix in the username. For example: my personal account at freenukehosting has the username davidw . Alle usernames in mySQL write usernames as davidw_username . On the other account my site-admin-user-for-cPanel is davidw1. So all SQL username for this account are like davidw1_username . I can't even change this prefix. The prefix is automatically added to the username. If I try to change the username in phpMyAdmin, I get an error saying that I do not have permission to change. If I look into the config.php file , there is the following:
---
<?php


// phpBB 2.x auto-generated config file
// Do not change anything in this file!

$dbms = 'mysql4';

$dbhost = 'localhost';
$dbname = 'davidw1_phpbb1';
$dbuser = 'davidw1_phpbb1';
$dbpasswd = 'somethinghere';

$table_prefix = 'phpbb_';

define('PHPBB_INSTALLED', true);

?>
---
If I change the davidw1 to davidw, I still get the above mentioned errors. I thought that the dbpasswd was the same as the admin password in the phpBB mySQL table phpbb_users. But the MD5 hash is different then the "somethinghere" above. The MD5 password is 32 characters long and the above is only 10 characters long. Even if I try to change the user password in the cPanel mySQL panel, it does not help.

I am really worried that freenukehosting does not let me make a good backup of the database... one that I really can restore!

Please advise!

Regards,
davidw

Hi DarkminD and all!

I have solved my problem and could make a succesful restore to another site other than the original site (they are both on the same server).

There are actually some extra steps to take, compared to what you explained to me, DarkminD. But you really gave me some great clues. I will, at a later time, make a turtorial, which I'd like to show you and we can discuss this. When we are finished, I propose that we move it to the tutorial forum.

One of the main problems, is the fact that both of my sites are located on the same server (IP) at freenukehosting. This means that there are some small, but important changes to the mySQL database file (import file).

I will be back soon! :roll:

Regards,
davidw

i have the same problem lol

hi Davidw!
I vary happy when i know you solved your problem. !
I can't understand all of your words (my English very bad, it's true!) so i can't explain what you need.
Wait for your news!

DarkminD,
What languages do you speak??

Maybe (but probably not) I can get somebody to translate...

Regards,
Davidw :wink: