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.

If purchased after July 2020

Step 1 of 10

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

Manage Web Hosting

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

If purchased before July 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.