1. Go to 'backup', under the 'Site Management' header in Cpanel.
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.
