How do I export a MySQL database?
This FAQ will help you to export your database from your Web hosting package.
The below video and step by step instructions will help you to export your database from your 123 Reg hosting package.
Need to import your database instead? Click to see how to do this.
Title: How do I export a MySQL Database?
In this video we will show you how to export your MySQL database from your web hosting package.
Log into 123 Reg control panel.
To begin, log into your 123 Reg control panel.
In the Web Hosting section, select the hosting package and click on the manage button.
Ok, now click on MySQL Databases.
You will now need to log into the database that you wish to export.
This will open up pHpMyAdmin.
Click on the database you wish to export and then click on the Export button.
Just here you will see all of the tables in the database, if you wish to export all of them, just ensure they are all highlighted.
Make sure that the SQL option is selected.
Now click on the Go button.
Once your database is exported you will see it in your web browser.
You can now save it somewhere on your computer, maybe in a back-up folder if you are creating it as a back-up copy.
That’s it; your database has been exported.
Please note that databases are not automatically backed-up on your web hosting package, so it’s a good idea to regularly export and back it up.
Step 1 of 12
Log in to your 123 Reg control panel
Step 2 of 12
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.
Step 4 of 12
In the Web Tools section, click on MySQL Databases.
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.
Step 6 of 12
This will open up phpMyAdmin.
Step 7 of 12
Click on your database in the top left hand corner.
Step 8 of 12
Now click on the Export tab.
Step 9 of 12
You can now choose the tables in the database you would like to export.
Step 10 of 12
Ensure that the MySQL button is selected.
Step 11 of 12
Now click on the Go button.
Step 12 of 12
Your database will start to download in your Web Browser.
