How to backup Mysql Database.
First, log in to your cPanel using your username and password.
Once in cPanel, search or navigate to the Files section and locate the Backups feature.
Under Download a MySQL Database Backup, click the name of the database you’d like to backup.
Click Save As to download a zip file of your database, then select a destination where you’d like the backup to be saved locally.
How to Restore Mysql Database.
To restore your MySQL databases, please do the following:
Locate and select the Backups tool from within the Files section.
Next, in the window titled Restore a MySQL Database, click the Browse button.
Navigate to the folder where you saved your database’s backup file and select the .sql.gz file which you want restored. Click the Open button and then click on Upload.
Now your MySQL database should be restored.
