How to backup your MYSQL database

Applies to: Dynamic Hosting, Premium Hosting, Unlimited Hosting, Multisite hosting

We advise that you take regular backups of your database. Creating backups not only protects you from data loss it can also protect you from accidental deletion and human error.

1. Go to http://domain.com/phpmyadmin (replace domain.com with your actual domain name)
2. Log in to phpMyAdmin with your database username and password
3. Click on the database you want to backup in the left hand column
4. Click on the Export tab. You shouldn’t need to change any of the default options
5. In File name template at the bottom of the page enter a name for the backup file (use underscores _ instead of spaces) You can also compress the backup file which will reduce the file size if you are backing up a large database
6. Finally click the Go button and your browser will start to download your database backup file

You can use your backup file to restore your MYSQL database to the state it was when the backup was taken in future if required.

Here is a quick demonstration

Similar articles:

• How to back up your website
• How to restore your MYSQL database
• How to use a database with Perl

Try our search Search