How do I import & export a MSSQL database?

This article applies to 123-reg Windows 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.

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 MSSQL Database link in the Web Tools section of your hosting control panel.

5

In the Manage Databases section press the Manage button to access your database administration area.

6

Click on the Import option in the Database menu.

7

Click on the Choose File button.

8

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

9

Click on the Import button.

10

Your import will have been successfully uploaded.


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.

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 MSSQL Database link in the Web Tools section of your hosting control panel.

5

In the Manage Databases section press the Manage button to access your database administration area.

6

Click on the Export option in the Database menu.

7

Click on the Export button.

8

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.