To create a backup of your MySQL Database:
1. Log into cPanel.
2. In the Files section, click on the Backups icon.
3. Under Partial Backups > Download a MySQL Database Backup, click the name of the database you want to backup.
4. In the popup that appears, click Save As or select Save File.
5. Select a destination where you would like to store the backup locally.
6. lick Save.
The backup file will be downloaded to the destination you have chosen in a .sql.gz file which can be opened with Linux command line. The file can also be unzipped from a Windows-based machine with the appropriate software.
Restore a Home Directory Backup
1. Log into cPanel.
2. In the Files section, click on the Backups icon.
3. Under Partial Backups > Restore a MySQL Database Backup, click on the Browse button.
4. In the popup that appears, navigate to the appropriate destination and select the backup file you intend to use.
5. Click Open.
6. Click Upload.
