How do I import & export a MySQL database?

This article applies to 123-reg Linux Shared Hosting accounts.

Importing a Database

You may need to import a database if you are restoring an old version of your database or if you have an existing database that you wish to use on your 123-reg hosting package.

To Import a database, please do the following:

1

Login to your 123-reg control panel

 Control_Panel_Login.jpg
2

Scroll down to the Web hosting section.

3

Select the relevant domain name from the drop down box and click on the Manage button.

 Web_hosting_section.jpg
4

Click on the MySQL Database link in the Web Tools section of your hosting control panel.

5

In the Manage Databases section press the Manage button to access phpMyAdmin.

6

If you have a blank database, click on the database name in the left hand frame.

7

Click on the Import tab.

8

In the File to import section, press the Choose File button.

9

Navigate to the file you wish to import on your computer and press the Open button.

10

Click on Go to upload the file.

Exporting a Database

Exporting a database will give you a back up copy on your local computer of the data within 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 back up copies of your data in the unlikely event of corruption or loss of your data from the server.

To Export a database, please do the following:

1

Login to your 123-reg control panel

 Control_panel_login_button.jpg
2

Scroll down to the Web hosting section.

3

Select the relevant domain name from the drop down box and click on the Manage button.

 Web_hosting_section.jpg
4

Click on the MySQL Database link in the Web Tools section of your hosting control panel.

5

In the Manage Databases section press the Manage button to access phpMyAdmin.

6

If you have a blank database, click on the database name in the left hand frame.

7

Click on the Export tab.

8

Scroll down in the right hand frame until you see the Options section.

9

Select the Structure and data options.

10

Ensure that the Save as file box is ticked otherwise the backup will be displayed as a text file.

11

Choose if you wish to use the compression option. The size of your database will determine as to whether or not you want to use this option.

12

To start the export, click the Go button.

13

Click on the Save button if prompted and the file will be save locally.

Answer options

Your feedback was successfully added.

Answer tracking

Track

Watch the content of this article for changes.