123 Reg Support

How do I export a MySQL database?

gabe

This article will show you how to export your database from your Hosting package.

The below step by step instructions will help you to export your database from your 123 Reg Hosting package.

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 option phpMyAdmin from the navbar.

 

Step 3 of 7

Select your database in the top left-hand corner.

Step 4 of 7

Once done, click the Export tab in the navbar.

Step 5 of 7

If you only want to export specific tables, select Custom – display all possible options under ‘Export method’ and choose the tables in the database you would like to export.

Whichever option you choose, ensure that the SQL format is selected.

Step 6 of 7

Now click on the Go button. You’ll then be asked to open or save your file.

Step 7 of 7

Your database will start to download in your Web Browser.

 

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

Step 1 of 13

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 13

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.

 

Step 3 of 13

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

 

Step 4 of 13

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

 

Step 5 of 13

In the Web Tools section, click on MySQL Databases.


 

Step 6 of 13

In the Manage MySQL Databases section, enter the password for the database you wish to export and then click on Manage.


 

Step 7 of 13

This will open up phpMyAdmin.


 

Step 8 of 13

Click on your database in the top left hand corner.


 

Step 9 of 13

Now click on the Export tab.


 

Step 10 of 13

You can now choose the tables in the database you would like to export.


 

Step 11 of 13

Ensure that the MySQL button is selected.


 

Step 12 of 13

Now click on the Go button.


 

Step 13 of 13

Your database will start to download in your Web Browser.