Carrying over databases

Windac · #1 (**permalink**) 07-21-09, 11:07

My friend wants to change his webhosting service and he currently has quite a bit of stuff on his phpbb3 forums and joomla CMS. Is it possible for him to download the database from his current webhost and uploaded to his new webhost without any information being lost? Also, would he upload the database after installation or before installation of phpbb and joomla?

Quilceda · #2 (**permalink**) 07-21-09, 13:31

Here's what I'd do if I were in his shoes:

1) Announce to all the board members the upcoming move, just so that they're aware of the possibility of extended downtime.

2) Download the entire phpbb folder and the corresponding database(s) (you can do this pretty easily through PhpMyAdmin).

3) Put a "we're currently in the process of moving" notice up on the homepage.

4) Upload the phpbb folder to your new web space.

5) Create the new database(s) in your new hosting account (it's best to keep the same database name and user), and dump all the tables using the downloaded copy of your old database(s). Double check the config file.

6) Test everything.

Gelato · #3 (**permalink**) 11-11-09, 11:58

Quote:

Originally Posted by Windac

My friend wants to change his webhosting service and he currently has quite a bit of stuff on his phpbb3 forums and joomla CMS. Is it possible for him to download the database from his current webhost and uploaded to his new webhost without any information being lost? Also, would he upload the database after installation or before installation of phpbb and joomla?

How did it work? Quilceda's steps are how I would have done it as well. It is a decent approach to taking care of it. Definitely should have been pretty simple.