To back up your WordPress database, first log into your cPanel account and under the Databases heading, click on phpMyAdmin
Once in phpMyAdmin click on the database name listed on the left
Next click on Export near the top, leave everything as default and then click “Go”
A dbname.sql file will automatically be downloaded to your local computer.
Once it has finished downloading, your backup is complete.