Backup/restore MySQL databases from cPanel
To backup the databases please do the following:
1.Login to your control panel and click Backups.
2.Under Download a MySQL Database Backup, click the name of the database.
3.Click Save As.
4.Select a destination for where you would like the back up to be saved, locally.
Once you have a backup, if you ever inadvertently lose your data, then you can restore the database easily and quickly.
To restore a database, please do the following:
1.Login to your control panel and click Backups.
2.Click the Browse button next to the option which says Restore a MySQL Database.
3.Select the .sql.gz file which you want restored.
4.Click the Open button and click the Upload button.