Sign Up / Log In
Need help?
1300 210 210
Online Support Web Hosting

How to backup MySQL databases

Before you update your website, or simply make some changes, it is highly recommended that you back up your website files first. This is so you can easily restore your website to a previous version, in case it crashes or some of its files or folders get corrupted.

If you want to know how to get backups of your website files, click the links below:

If you only want to create backups of your MySQL databases, however, you can do so via the Hosting Manager. To know how to access your Hosting Manager, click the link below:

Once logged in the Hosting Manager, you can create MySQL database backup files using either the Backup or the Backup Wizard features.

With Backup

To use the Backup feature to back up your MySQL database/s, follow the steps below:

  1. Click Sign Up / Log In at the top of this page.
  2. Select Hosting Manager from the drop-down menu.
  3. Enter your username and password, and click Log In.
  4. On the Home page, click the word Files or the [ v ] arrow symbol on the right side.
  5. Click the Backup icon, which is next to the Backup Wizard icon.
  6. Under Partial Backups, go to Download a MySQL Database Backup.
  7. Click the Select Database field, or the arrow to the right, to access the drop-down menu.
  8. Choose the database you want download a backup copy of.
  9. Click the Download button on the right.
    Your browser will then automatically start downloading the MySQL database backup file.

With Backup Wizard

To use the Backup Wizard feature to back up your MySQL database/s, follow the steps below:

  1. Click Sign Up / Log In at the top of this page.
  2. Select Hosting Manager from the drop-down menu.
  3. Enter your username and password, and click Log In.
  4. On the Home page, click the word Files or the [ v ] arrow symbol on the right side.
  5. Click the Backup Wizard icon, which is next to the Backup icon.
  6. Click the Backup button.
  7. In the next page, under the Select Partial Backup, click MySQL Databases.
  8. Next, under the Databases column, click the database/s you want to create backups for.
    Your browser will then automatically start downloading the MySQL database/s backup file you clicked.

Note: MySQL Database backup file will have the .sql.gz file extension.

Congratulations, you now know how to back up your MySQL databases.

Was this helpful? Yes No 100% of people found this helpful.
we're
online
Need Help? Chat Now