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.