Restore A Phpbb And Mysql Db

[MarkMan]

So I have a backup of a test forum db and would like to practice restoring it, in case something happens to my real forum. I deleted the BB the mySQL db. I know how to create a forum and am able to restore the db via Cpanel>Backup, but the forum only contains the generic initial install data.

 

How do I recreate the BB and tie it to the correct mySQL db?

 

-thanks

[TweezerMan]

I'm not really familiar with restoring a database backup using CPanel - I use phpMyAdmin instead.

 

Whether you use CPanel or phpMyAdmin, you should create the database first and add a user to that database before restoring a database backup. (This is required if you use phpMyAdmin to restore the database; I'm not sure if it is or not when using CPanel to restore the database.)

 

After the empty database has been created, the database that a backup will be restored to is easily selectable in phpMyAdmin. (In fact, you have to tell phpMyAdmin which database to restore a backup to.)

 

To restore a database using phpMyAdmin, you would select the database in the dropdown box on the left side of the page, then click the 'SQL' tab. Near the bottom of the page is a 'Location of the textfile:' box. Click the 'Browse' button to select the backup file (located on your PC), which will then be uploaded to the server and the data restored to the database.

 

Hope this helps...

[MarkMan]

That worked, thanks

 

One thing I noticed is that the same directory name must be used for the newly created forum so that it matches the old forum directory name from which the db backup came.

[MarkMan]

Weird, does anyone know why this is appearing on the administration panel, or how to have it reflect the correct version? I installed a fresh version of phpBB 2.0.18, linked it to an empty db, then restored a backup db (which was from a 2.0.17 install).

 

I hope I don't have to install .17, restore the db, then update phpBB to .18

 

 

Your installation does not seem to be up to date. Updates are available for your version of phpBB, please visit http://www.phpbb.com/downloads.php to obtain the latest version.

The latest available version is phpBB 2.0.18. You are running phpBB 2.0.17.

[MarkMan]

Never mind, i just searched the DB for the old version number and manually changed it to .18

This is probably taboo, but it seemed to do the trick .... at least for the UI

 

Your installation is up to date, no updates are available for your version of phpBB.