This article explains how to take a backup or restore a backup using phpMyAdmin.
Backup MySQL Database
Step #1:
Login to cPanel and under the 'Databases' section select 'phpMyAdmin'.
Step #2:
Select the database you would like to backup from the left navigation.
Click the Export tab.
Step #3:
Choose the 'Quick' export method, select the 'SQL' option and click 'Go'.
The database dump will be downloaded to your local machine's default download location.
Restore MySQL database from a Dump
Step #1:
Choose the database we want to restore from the left navigation.
Step #2:
The phpMyAdmin script that restores the database does not drop the tables so click the 'Check All' check box.
Select the 'With selected:' drop-down menu and choose 'Drop'.
Step #4:
Click the 'Import' tab and browse for the database backup.
Click Go.
Don't hesitate to use our live chat or support ticket system for any further questions or support you may require.