How to Backup and or Restore your MySQL Database Using phpMyAdmin
Backup your MySQL Database
Log into your cPanel account by pointing a browser to http://IPAddressOfServer:2083 and using the credentials provided.
On the Home screen, scroll down to Databases and click on phpMyAdmin.
Select the database you would like to backup from the left navigation tree.
Click the Export
Choose the Quick export method and click Go.
Your export of your database will be downloaded to your local machine's default downloads location.
Restore your MySQL database from a Backup
- Choose the database you want to restore from the left navigation tree.
- The phpMyAdmin script that restores your database does not drop the tables first. Click the Check All check box.
- Click the With selected: drop down menu and choose Drop.
- Confirm by clicking Yes.
- Click the Import tab.
- Click the Choose File button to browse for the MySQL backup.
- Click Go.