Database Restore
Restoring a backup with phpMyAdmin
- To restore a database, you click the SQL tab (on newer versions of phpMyAdmin there is an "Import" tab).
- On the "SQL"-page , unclick the show query here again.
- Browse to your backup of the database.
- Click "Go".
Restoring a backup with SSH/Telnet
- mysql -uUSERNAME -p DBNAME < /PATH/TO/DUMP.SQL
- USERNAME - this username which you use to access MySQL.
- DBNAME - the name of the database used for MyBB.
- /PATH/TO/DUMP.SQL - this is the path to the backup file that you have on the server. You will have to upload it to the server since you used phpMyAdmin to back it up.
Don't have SSH/Telnet?
If you don't have SSH/Telnet access, you can download a restoring tool called BigDump. This works well for databases that are large and timeout phpMyAdmin.