Backup/restore MySQL databases in cPanel
Difficulty
Easy
Backing up the databases
-
Login to your control panel and click Backups.
-
Under Download a MySQL Database Backup, click the name of the database.
-
Click Save As.
-
Select a destination for where you would like the back up to be saved, locally.
Restoring the databases
-
Login to your control panel and click Backups.
-
Click the Browse button next to the option which says Restore a MySQL Database.
-
Select the .sql.gz file which you want restoring.
-
Click the Open button and click the Upload button.
