How do I restore my MySQL database?

This article will explain how you can restore MySQL databases from a backup.

Important: You must have a manual backup of your files to follow this process. It is your responsibility to keep an up-to-date backup of your databases as some versions of our Hosting packages do not come with a backup service.

Simply click on a title below to skip to the most appropriate FAQ. You can also click the Top button to return and make another selection.

Web Hosting plans purchased after July 2020 / Premium Hosting plans purchased after August 2020 (cPanel)

Step 1 of 8

Start by accessing your Web Hosting dashboard.

 

Step 2 of 8

On your dashboard, select the cPanel Admin button that appears above Settings.

Dashboard

 

Step 3 of 8

Select Backup Wizard from the Files section.

Select Backup Wizard

 

Step 4 of 8

Select the Restore option.

Restore

 

Step 5 of 8

Select MySQL Databases from the Select Restore Type heading.

MySQL

 

Step 6 of 8

Select Browse under the ‘Restore a MySQL Database Backup’ option.

Choose

 

Step 7 of 8

Find and choose the backup SQL file on your computer. This will typically be a .gz file.

select file

 

Step 8 of 8

Select Upload to start the process.

Upload

 

Web Hosting plans purchased before July 2020 / Premium Hosting plans purchased before August 2020

Step 1 of 11

Start by logging in to your legacy Control Panel. For details on how to do this, please read the following article: How do I access and manage my products?

Step 2 of 11

From there, select Web Hosting or Premium Hosting within the ‘Manage active products’ section, depending on which product you wish to use.

Next, select Manage opposite the ‘(bought before XX/XX/XX)’ option.

Manage Shared Web Hosting

 

Step 3 of 11

This will show you an overview of your current hosting packages. Click Manage for the account you wish to use.

Manage Legacy hosting

 

Step 4 of 11

On the next page, select Manage for the domain you wish to update.

Manage hosting domain

 

Step 5 of 11

Click on the MySQL Database link in the Web Tools section of your hosting control panel.

 

Step 6 of 11

In the Manage Databases section enter the new password in the empty field and press the Modify button.

 

Step 7 of 11

Click on the database name in the left hand frame.

 

Step 8 of 11

Click on the Import tab.

 

Step 9 of 11

In theFile to import section, press the Choose File button.

 

Step 10 of 11

Navigate to the file you wish to import on your computer and press the Open button.

 

Step 11 of 11

Click on Go to upload the file.

 

Restarting MySQL following an error

Please contact our Support team using the Ask a question tab in the support area of our website, supplying the full error message you are receiving.