Sign Up / Log In
Need help?
1 213 559 2459
Online Support Web Hosting

How to restore a MySQL database backup

Regularly creating database backup files is highly recommended, especially if you have important web data stored in them. This is to ensure you will always have previously working versions of your databases that you can readily use in case your website gets infected with a virus, is hacked, or becomes corrupted.

How to back up your MySQL database

Before you can restore a MySQL database to a previously working version, you first need to create a backup copy of it. You can do so this inside the Hosting Manager.

Important Note: When restoring a MySQL database, it is best that you use the most recent working backup file you have. This is so it will be easier for you to work on and you will have the least revisions to implement within your database.

To know how to create and download backup copies of your database, click the links below:

How to restore a MySQL database backup

In case something unfortunate happens to one of your MySQL databases and some of your data gets lost or corrupted, you have the option to restore it to a previously working version. To do this, you need to have database backup files.

Once you have your database backup files, you will now be able to restore a MySQL database with the Backup and Backup Wizard features in your control panel.

Using Backup

To restore a MySQL database backup using the Backup feature in Hosting Manager, 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 button, which is next to the Backup Wizard icon.
  6. Next page, under Partial Backups, proceed to the Restore a MySQL Database Backup section. Click Choose File.
  7. In the pop-up box, locate and select from within your computer the apt database backup file you want to upload. You can also simply drag the said database backup file from your local hard drive to the Choose File box.
  8. Click Upload.

This will take a few minutes, depending on the size of your backup file.
In the next screen, you will get a notification that reads Restoring Database and a grey box below it with a list of database files that have been restored.

Using Backup Wizard

To restore a MySQL database backup using the Backup Wizard feature in Hosting Manager, 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 button, which is next to the Backup icon.
  6. On the next page, click Restore.
  7. Then, click MySQL Databases.
  8. Next, click Choose File, then locate and select from within your computer the apt database backup file you want to upload. You can also simply drag the said database backup file from your local hard drive to the Choose File box.
  9. Click Upload.

This will take a few minutes, depending on the size of your backup file.
In the next screen, you will get a notification that reads Restoring Database and a grey box below it with a list of database files that have been restored.

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

Congratulations, you now know how to restore a MySQL database backup file.

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