How do I back up my MySQL database?

This article will explain how you can back up 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.

The following steps apply to Web Hosting plans purchased after July 2020 and Premium Hosting plans purchased after August 2020 (cPanel):

Step 1 of 7

Start by accessing your Web Hosting dashboard.

 

Step 2 of 7

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

Dashboard

 

Step 3 of 7

Select Backup Wizard from the Files section.

Select Backup Wizard

 

Step 4 of 7

Select the option Back Up.

Backup

 

Step 5 of 7

Select MySQL Databases under the Select Partial Backup heading.

MySQL

 

Step 6 of 7

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

final step

 

Step 7 of 7

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.