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)
On your dashboard, select the cPanel Admin button that appears above Settings.
Select Backup Wizard from the Files section.
Select the Restore option.
Select MySQL Databases from the Select Restore Type heading.
Select Browse under the ‘Restore a MySQL Database Backup’ option.
Find and choose the backup SQL file on your computer. This will typically be a .gz file.
Select Upload to start the process.
Web Hosting plans purchased before July 2020 / Premium Hosting plans purchased before August 2020
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?
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.
This will show you an overview of your current hosting packages. Click Manage for the account you wish to use.
On the next page, select Manage for the domain you wish to update.
Click on the MySQL Database link in the Web Tools section of your hosting control panel.
In the Manage Databases section enter the new password in the empty field and press the Modify button.
Click on the database name in the left hand frame.
Click on the Import tab.
In theFile to import section, press the Choose File button.
Navigate to the file you wish to import on your computer and press the Open button.
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.