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:

Step 1 of 10

Start by logging in to your Control Panel and scroll down to ‘Web Hosting’. From there, select Manage.

General Control Panel

 

Step 2 of 10

On the next page, select Manage for the account you wish to use.

Web Hosting Manage

 

Step 3 of 10

Select the three-dot icon for the package you want to edit. From there, choose Settings from the drop-down menu that appears.

cPanel Admin

Step 4 of 10

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

Dashboard

 

Step 5 of 10

Select Backup Wizard from the Files section.

Select Backup Wizard

 

Step 6 of 10

Select the Restore option.

Restore

 

Step 7 of 10

Select MySQL Databases from the Select Restore Type heading.

MySQL

 

Step 8 of 10

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

Choose

 

Step 9 of 10

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

select file

 

Step 10 of 10

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.