phpbb Transfer

Shoeless Llama · Post by **Shoeless Llama** » Mon Nov 01, 2004 2:19 pm

I am trying to transfer our old phpbb forum onto our new webspace with nuclearfallout, but am having some difficulties. I have tried utilizing the backup feature within phpbb as well as just moving the entire phpbb directory over from our old host to our nuclearfallout ftp. If someone could give me a step by step process on this I would greatly appreciate it. I apologize if this has already been addressed previously on the forums. I could not find a topic on it. Thanks.

-[NGK]Llama

Nick|NFo · Post by **Nick|NFo** » Mon Nov 01, 2004 2:37 pm

you need to create a backup of the mysql database you have at the existing site, and bring it over here. you can use the phpbb backup database utility built-in its admin panel. I strongly recommend using phpmyadmin for your control of mysql databases for our webspace.

There can be some errors that occur, such as different mysql database versions, compatibility issues, etc.

What you need to transfer is all the files from the "forums directory", .htaccess files include, any other hidden files, over to NFo webspace, into a folder called like 'forums'. Now you need to transfer the mysql database and make sure none of it is corrupted.

EDIT: Please read the following post for how to transfer phpBB forums from host to host.

Shoeless Llama · Post by **Shoeless Llama** » Mon Nov 01, 2004 2:50 pm

Thanks for the help. We really appreciate it. I was afraid it would prove to be a daunting task, but I just hate to lose all the information that accumulates on a message board over the course of a year. We'll get to work on this and see how it comes out.

-[NGK]Llama

Nick|NFo · Post by **Nick|NFo** » Mon Nov 01, 2004 3:06 pm

its alot easier with phpbb backup database utility, read below:

you need to have the exact same phpbb files from your old host, so use a FTP client to download them to your desktop.

Now, backup your phpBB forums. You can do this at the Admin Control Panel --> Backup Database. Make sure you back up both the structure and data. Save the backup to your desktop.

Before uploading your copy of the phpBB files, you will have to open the config.php in NotePad or Wordpad(depending on formatting). Open the file, find all of the needed variable data fields such as mysql database info from old host, and change them to settings from NFo, username, password, etc. When thats complete, save it.

Now upload the phpBB files you made a copy of, from your desktop to NFo space into a directory named forums or whatever folder name you want it to be.

Once you're finished uploading the phpBB files, go into phpmyadmin on NFo webspace (that you installed), and choose to run the query from a textfile. Click on browse and find the *.sql backup file you've backed up.
You should never have to upload this database to the site manually, only use this utility in phpmyadmin. Click Go to upload it. If the upload is successful, then your forums should be working and you can login as your username.

Hope that helps on how to use the phpbb backup utility in its admin panel and how to use phpmyadmin.

Shoeless Llama · Post by **Shoeless Llama** » Thu Nov 04, 2004 7:38 am

We're now getting this error after uploading the backup through phpmyadmin:

"phpBB : Critical Error

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'ngk.phpbb_config' doesn't exist

SELECT * FROM phpbb_config

Line : 176
File : /usr/www/ngk/forums/common.php"

Any ideas?

-[NGK]Llama

Nick|NFo · Post by **Nick|NFo** » Thu Nov 04, 2004 8:15 am

you need to do the file changes to includes/constants.php and make sure you uploaded all the tpl's and didnt accidently delete anything else or not upload anything.

Check your constants.php file and common.php, make sure it's not corrupted. Try replacing it.

SQL Error : 1146 Table 'ngk.phpbb_config' doesn't exist

the ngk is your database name from us, and phpbb_config is the table name

check to see if you have that table phpbb_config on your database, using phpmyadmin. it could have been dropped or misplaced.

make sure that the prefix in config.php being used on your forum is set to this:

Code: Select all

$table_prefix = 'phpbb_';

you could be running into some problems if you had installed some custom "hacks" in your phpbb files.

those are some common errors to fix, if these dont fix it, try searching on google.com for other support or ask on specific phpbb support forums, theres a bunch

Have Fun

Shoeless Llama · Post by **Shoeless Llama** » Thu Nov 04, 2004 11:46 pm

We got it working. We just had to break down the backup file into units under 2 megs each to get them to transfer effectively. Thanks for the help!!!

-[NGK]Llama

Nick|NFo · Post by **Nick|NFo** » Thu Nov 04, 2004 11:49 pm

Shoeless Llama wrote:We got it working. We just had to break down the backup file into units under 2 megs each to get them to transfer effectively. Thanks for the help!!!

-[NGK]Llama

sweet, good to hear.