↩ MySQL Basics

Database Backups

There are many ways to create a backup copy of your MySQL databases. Here are some of the easiest.

1. phpMyAdmin. cPanel includes the "phpMyAdmin" script, which allows you to directly manipulate your databases on the server. Using phpMyAdmin's solid "Export" features, you can export your database in many different formats. Simply select your database from within phpMyAdmin and click the "Export" tab for more options. For backups, we'd recommend ticking the "Save as a File" checkbox, and clicking "Go". For large databases, you may prefer to choose the "gzipped" option also.

2. cPanel. cPanel also has two built-in backup features - "Backups" and "Backup Wizard". Both of these will allow you to take backups of your database, with the "Backups" option allowing you a few more options than the more automated and simpler "Backup Wizard" facility.

3. Backup Script. If you'd rather automate the process of backing up your databases, you may prefer to use a backup script. A database backup script can easily be set to run at regular intervals by adding a "Cron Job" from within the cPanel.

Note: Because the process of backing up a large database can be resource-intensive, we would ask that you only run this script at reasonable intervals - for example, nightly.