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
Start by logging in to your Control Panel and scroll down to ‘Web Hosting’. From there, select ‘Manage’.
On the next page, select ‘Manage’ for the account you wish to use.
Select the three-dot icon for the package you want to edit. From there, choose ‘Settings’ from the drop-down menu that appears.
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.
If purchased before July 2020
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.