How do I backup MySQL Databases in cPanel?

MySQL databases can be backed up by doing the following:

1. Log into your cPanel and click the Backup icon.
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, but the cpanel method is quick and easy

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I backup my entire site in cPanel?

Entire accounts can be backed up by doing the following: 1. Log into your cPanel and click the...

Error 550 – “The recipient cannot be verified”

On servers running cPanel, you may find that mail sent to valid users it bounced back by your...

Ports that must be open to run cPanel behind a firewall / IPTables

20 ftp tcp inbound/outbound21 ftp tcp,udp inbound/outbound22 ssh tcp inbound25 smtp tcp...

Quotas in WHM

ssh into the server then issue:/sbin/quotaoff -av/sbin/quotacheck -augvm/sbin/quotaon -av

Running exim on a different port

Log into WHM and click on "Service Manager" under the Service Configuration grouping....