How to backup your MYSQL database

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 (replace 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. 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

Related guides

  • How to create a MYSQL database
  • Managing your MYSQL database
  • How to restore your MYSQL database
  • How to backup your website
  • Check out some of our related guides

    Need a hand? Search over a hundred step-by-step support guides