How do I export a MySQL database?

This FAQ will help you 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.

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.

phpMyAdmin

 

Step 3 of 7

Select your database in the top left-hand corner.

Database

Step 4 of 7

Once done, click the Export tab in the navbar.

Export

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.

Export Database

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.

 

If purchased before July 2020

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

Step 1 of 13

Start by logging in to your 123 Reg Control Panel.

 

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.

Manage Shared Web Hosting

 

Step 3 of 13

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 13

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

Manage hosting domain

 

Step 5 of 13

In the Web Tools section, click on MySQL Databases.

click on the databases button
 

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.

log into your database
 

Step 7 of 13

This will open up phpMyAdmin.

open up phpmyadmin
 

Step 8 of 13

Click on your database in the top left hand corner.

select your database
 

Step 9 of 13

Now click on the Export tab.

click on export
 

Step 10 of 13

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

choose the database you wish to export
 

Step 11 of 13

Ensure that the MySQL button is selected.

ensure MySQL is selected
 

Step 12 of 13

Now click on the Go button.

click go
 

Step 13 of 13

Your database will start to download in your Web Browser.

database downloaded