This article applies to 123-reg Linux Shared Hosting accounts.
This article will show you how to Import or Export a MySQL 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:
Login to your 123-reg control panel
Scroll down to the Web hosting section.
Select the relevant domain name from the drop down box and click on the Manage button.
Click on the MySQL Database link in the Web Tools section of your hosting control panel.
In the Manage Databases section press the Manage button to access phpMyAdmin.
If you have a blank database, click on the database name in the left hand frame.
Click on the Import tab.
In the File to import section, press the Choose File button.
Navigate to the file you wish to import on your computer and press the Open button.
Click on Go to upload the file.
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:
Click on the Export tab.
Scroll down in the right hand frame until you see the Options section.
Select the Structure and data options.
Ensure that the Save as file box is ticked otherwise the backup will be displayed as a text file.
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.
To start the export, click the Go button.
Click on the Save button if prompted and the file will be save locally.
Watch the content of this article for changes.