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.

Th e following steps apply to Web Hosting plans purchased after July 2020 and Premium Hosting plans purchased after August 2020:

Step 1 of 9

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

General Control Panel

 

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

 

The following steps apply to Web Hosting plans purchased before July 2020 and Premium Hosting plans purchased before August 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.