How do I back up my MySQL database?

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 your 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 backup copies of your data in the unlikely event of corruption or loss of your data from the server.

If purchased after July 2020

Step 1 of 9

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

Manage Web Hosting

Step 2 of 9

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

Web Hosting Manage

Step 3 of 9

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 9

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

Dashboard

Step 5 of 9

Select Backup Wizard from the Files section.

Select Backup Wizard

Step 6 of 9

Select the option Back Up.

Backup

Step 7 of 9

Select MySQL Databases under the Select Partial Backup heading.

MySQL

Step 8 of 9

In the Databases list, select the database you wish to backup.

final step

Step 9 of 9

Your backup will now be downloaded to your computer as a .gz file.

Backup Download

If purchased before July 2020

Step 1 of 2

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

Step 2 of 2

In the Manage Databases section press the Backup button to start downloading your database to your computer.

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.