How do I export a MySQL database?

This FAQ will help you to export your database from your Web hosting package.

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

If purchased after July 2020 (cPanel Web Hosting)

Step 1 of 9

Start by logging in to your Control Panel and scroll down to ‘Web Hosting’. From there, select ‘Manage’.

Manage Web Hosting
 

Step 2 of 9

On the next page, select ‘Manage’ for the account you wish to use.

Web Hosting Manage
 

Step 3 of 9

Select the three-dot icon for the package you want to edit. From there, choose ‘Settings’ from the drop-down menu that appears.

cPanel Admin
 

Step 4 of 9

On your dashboard, select the option phpMyAdmin from the navbar.

phpMyAdmin
 

Step 5 of 9

Select your database in the top left-hand corner.

Database
 

Step 6 of 9

Once done, click the Export tab in the navbar.

Export
 

Step 7 of 9

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 8 of 9

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

Step 9 of 9

Your database will start to download in your Web Browser.
 
 

If purchased before July 2020

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


Step 1 of 12

Log in to your 123 Reg control panel


 

Step 2 of 12

Scroll down to the Web hosting section.

scroll down to the web hosting section
 

Step 3 of 12

Select your domain name using the drop-down menu and then click on the Manage button.

select your domain name and click on the manage button
 

Step 4 of 12

In the Web Tools section, click on MySQL Databases.

click on the databases button
 

Step 5 of 12

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 6 of 12

This will open up phpMyAdmin.

open up phpmyadmin
 

Step 7 of 12

Click on your database in the top left hand corner.

select your database
 

Step 8 of 12

Now click on the Export tab.

click on export
 

Step 9 of 12

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

choose the database you wish to export
 

Step 10 of 12

Ensure that the MySQL button is selected.

ensure MySQL is selected
 

Step 11 of 12

Now click on the Go button.

click go
 

Step 12 of 12

Your database will start to download in your Web Browser.

database downloaded