This article applies to Linux Shared Hosting accounts.
This answer explains how you can backup your database so that in the event of a problem you have a copy of the data from you database.
Important: It is your responsibility to keep an up to date back up of your databases as your 123-reg hosting package does not come with a backup service. This is to ensure that you have usable and up to date back up copies of your data in the unlikely event of corruption or loss of your data from the server.
Backing up your MySQL database
To backup your MySQL database, please do the following:
2
Scroll down to the Web hosting section.
3
Select the relevant domain name from the drop down box and click on the Manage button.
4
Click on the Manage database option.
5
Click on the box shape icon under the Login column for the relevant database.
6
Enter your database username and password in the relevant boxes.
7
Click on the database name in the left hand frame.
8
Click on the Export tab.
9
Scroll down in the right hand frame until you see the Options section.
10
Select the Structure and data options.
11
Check the box for Save as file along with any compression options you require.
If this times out then your database may be too large to back up using a web browser. In this case you will need to use alternate means to back up your database.
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.