If you are looking to restore a Database, this tutorial can help you out. This is not a difficult thing to do but utmost care is required while doing so. To restore a database with phpMyAdmin, follow the instructions below:
Procedure:
- On the homepage of your cPanel, click on the phpMyAdmin icon under “Databases”.
- Click the Structure button.
- Click the Check All link.
- Select Drop from the drop down menu.
- You will be prompted to confirm whether you want to delete the tables. Choose Yes.
- When the tables are deleted, click on the Import button.
- Select the database file you want to restore from your computer.
- When you are done, click on the Go button.
- You will be informed when the Import is successfully finished.