Restore Question

[sapper]

I'm running a testboard and want to know if it's possible to restore a backup from my live board to give me some content to work with.

I'm running phpBB 3.0.7 PL1 on both boards

 

[Watch Me Sink]

Import the database through phpmyadmin/cPanel.

 

[sapper]

Can you give me some directions how to do this ?

 

[wigsaw]

Go to your ACP on live board - System - Backup Database - Either make a download file or store local.

If you store local (easy option) open up your FTP client , browse to your root of phpbb and find /store . Your file is there. Right click and Download to your desktop.

If you downloaded the file from ACP then ignore that. Open empty board. ACP - System - Restore Database and select the database file on your desktop.

Hope this helped!

 

[sapper]

Hmm tried that ad it times out with a database error

 

[wigsaw]

Hmm tried that ad it times out with a database error

Hm that's really quite odd.

Do you have phpmyadmin? You can select the database and export it. Then import it to the other board and work your config.php around it.

 

[CyberFreak]

If your database is big then the acp backup will not work as good. It is best to export it via phpmyadmin then go to the new database using phpmyadmin still and import it there.

 

[sapper]

I've now been told it's not possible if you don't have all the MODs that are on the live board on the test board.

I'm not that sure about what to do in phpmyadmin, and would need step by step instructions

 

[CyberFreak]

Make a copy of the forum files and use them files as they will have all the mod code in them and then when you connect it to the new copy of the database, that will have all the mod date in it.

Read this - http://www.phpbb.com/kb/article/transfe ... or-domain/

Information needed is "1) Using phpMyAdmin to Back Up the Database"

And to restore follow no. 1 under restore "1) If the database file is less than 2MB (exactly), follow these instructions"

Ignore the 2mb limit mentioned. I have restored much bigger databases with phpmyadmin. You could use bigdump if yo want which is option 2.

 

[Hitakashi]

@Fowlers post.
Actually it depends if the host changed some PHP settings to allow files larger then 2 MB's, If it just doesn't work with phpmyadmin then use bigdump

 

[sapper]

I know this is a big ask, but is there anyone out there willing to do this for me.

I've spent hours developing my test board only to be told that I need to transfer the database or start with a vanilla install, which would mean losing a years work on the live board, and probably losing what few members I do have in the process.