How do I restore my MySQL database?

This answer explains how in the event of a problem you can restore your database 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 123 Reg Hosting package do not come with a backup service.

The following steps apply to Web Hosting plans purchased after July 2020 and 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

 

The following steps apply to Web Hosting plans purchased before July 2020 and Premium Hosting plans purchased before August 2020:

Step 1 of 7

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

 

Step 2 of 7

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

 

Step 3 of 7

Click on the database name in the left hand frame.

 

Step 4 of 7

Click on the Import tab.

 

Step 5 of 7

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

 

Step 6 of 7

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

 

Step 7 of 7

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.