MyBB Community Forums

I have backed up the database through phpmhAdmin and i want to load it? How do i do that??
I dont see any import button on phpMyAdmin

Did you save the file to your hard disk? Did you choose SQL format?

If so, in phpmyadmin, click on the SQL button at the top and under "Location of the textfile" browse to where you saved the file and click Go.

I just realised though, you may want to clear the database out first.

James

yeah i did all this i select all and then empty then i loaded the .sql but nothing

#1050 - Table 'mybb_adminlog' already exists

Ok i did it. I had to delete the tables and load not to empty them

Sometime when restoring a database with phpmyadmin it will time out, thats why it gave you that error. There is a little tool you can use if you don't have SSH. http://www.ozerov.de/bigdump.php

Download that and you will have a restored database within seconds.

When I backup using phpmyadmin, I like to select the drop tables if exist option.. That way it drops the DB tables if they exist and rebuilds them from the text file.