Your cPanel Shared Hosting MySQL databases can be backed up by doing the following:
- Go to "backup" under the "Site Management" head in cPanel.
- Underneath "Download a SQL DB Backup", click on the database name that you wish to backup.
- Select a place and filename for your database backup file on your local computer.
- 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 shell, but when using cPanel, this method is quick and easy.
For large databases mysqldump is recommended.