Downloading a MySQL database backup with cPanel is easy. Here’s how to do it.
Log into your cPanel and look for the Backup option in the Files section.
Click on that Backup link and you will see a page that gives you options to download full site backups, home directory backups, MySQL backups and email forwarder/filter backups.
Look specifically for the Download a MySQL Database Backup section.
Right click on the link for the database that you want to backup and click “save as” to save the database to your computer. It will be downloaded as a compressed file likely named something like this: “database_name.sql.gz” (gzip).
And that’s it, you now have a backup of your database stored on your local computer.