Even though your managed hosting package will likely include automatic backups of your database which can then be restored in an emergency, you may find it necessary to restore a backup of your database manually at some point in time. It is always good policy to have a database management plan that includes knowing how to restore a database if needed, and restoring a database can be easily achieved using PHPMyadmin.
- Logon to your account and in Cpanel find and open PHPMyadmin.
- In the left-hand column choose the database you want to restore.
- On the page that opens you will see a list of all the tables in that database. Look at the end of the tables column and click "Check All", or manually select the specific tables you want to restore if only a partial restoration of the database is needed.
- Next to the "Check All/Uncheck All/Check tables having overhead" is a menu box. Click the down arrow and select "Drop" among the menu options.
- You will immediately be presented with a prompt asking if you really want to drop (delete) the tables you have selected.
- Click the Yes button.
- Click the Go button. The tables you selected will be deleted.
- Click the Import tab
- Click the Browse button and find your saved database backup file to be restored.
- Click the Go button and the backup file will be uploaded and the SQL commands executed and your database will be re-created using the backup files.
