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.

Simply click on a title below to skip to the most appropriate FAQ. You can also click the Top button to return and make another selection.

Web Hosting plans purchased after July 2020 / 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

 

Web Hosting plans purchased before July 2020 / Premium Hosting plans purchased before August 2020

Step 1 of 6

Start by logging in to your legacy Control Panel. For details on how to do this, please read the following article: How do I access and manage my products?

Step 2 of 6

From there, select Web Hosting or Premium Hosting within the ‘Manage active products’ section, depending on which product you wish to use.

Next, select Manage opposite the ‘(bought before XX/XX/XX)’ option.

Manage Shared Web Hosting

 

Step 3 of 6

This will show you an overview of your current hosting packages. Click Manage for the account you wish to use.

Manage Legacy hosting

 

Step 4 of 6

On the next page, select Manage for the domain you wish to update.

Manage hosting domain

 

Step 5 of 6

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

 

Step 6 of 6

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.