How do I backup MySQL databases in my cPanel Shared Hosting account? Εκτύπωση

Your cPanel Shared Hosting MySQL databases can be backed up by doing the following:

1. Go to "backup" under the "Site Management" head in cPanel.
2. Underneath "Download a SQL DB Backup", click on the database name that you wish to backup.
3. Select a place and filename for your database backup file on 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 shell, but when using cPanel, this method is quick and easy.

For large databases mysqldump is recommended.