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.