Retrieve a Standard Database Backup in cPanel
2. Click the Backup Manager link in the Files section.
3. Under Other cPanel Backup Plugins, click on cPanel Backups.
4. Now under the Download a MySQL Database Backup section, click on the name of the database you wish to download. If you aren’t sure which database is associated with your site, check the name in the site’s configuration data. For WordPress sites, this is your wp-config.php file.
5. On your local machine, go to the folder your web-browser downloaded the database backup and you should now see the compressed file.
