Backup WordPress SQL Database in Cpanel?

By January 4, 2015IT Solutions
  1. Login to your cPanel.
  2. cpanel click on backupsUnder the files section, click on Backups.
  3. cpanel backups click on database name to downloadNow under the Download a MySQL Database Backup section, click on your database name, in this case userna5_wordpress.
  4. windows file explorer viewing database backupGo to the folder your web-browser downloaded the database backup to, and you should now see the compressed .sql.gz file.

Now you’ll have a good working copy of your database locally stored safely on your own computer. If you delete something by accident, or are having any other database problems, you can then restore your database from that good backup.