How to backup Mysql Databases in Cpanel?

Mysql databases can be backed up by following steps 

• 1. Login to cPanel interface >>> Files >>> Backups >>> 
• 2. Underneath where it says "Download a SQL DB Backup", click on the database name that you wish to backup
• 3. Select a place and filename for you to save on to your local computer
• 4. Do NOT attempt to open this file with Winzip.

You have now successfully backed up your Mysql database with Cpanel.
There are other ways to accomplish this task, such as doing a dump from
PhpMyadmin, or doing a dump from the command line, but the cpanel
method is quick and easy.