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)
On your dashboard, select the cPanel Admin button that appears above Settings.
Select Backup Wizard from the Files section.
Select the option Back Up.
Select MySQL Databases under the Select Partial Backup heading.
In the Databases list, select the database you wish to backup.
Your backup will now be downloaded to your computer as a .gz file.
Web Hosting plans purchased before July 2020 / Premium Hosting plans purchased before August 2020
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?
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.
This will show you an overview of your current hosting packages. Click Manage for the account you wish to use.
On the next page, select Manage for the domain you wish to update.
Click on the MySQL Database link in the Web Tools section of your hosting control panel.
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.