Knowledgebase
How to create, backup, access and restore MsSQL database?
Posted by Tim Botherway on 23 May 2017 04:34 PM

This only applies to Windows Web Hosting.
For Linux and MYSQL click here

This article is ideal for people moving websites that have a database containing data. You will find this most helpful if you are using a CMS (Content Management Suite) such as Joomla, Wordpress and Drupal . You will also find this helpful if your website contains a forum.

 

Documentation Plan
Learn to use MsSQL
Create and access MyLittleAdmin for SQL database
Backup databases with MyLittleAdmin
Restore databases with MyLittleAdmin

 

 


 

If you want to learn how to use MsSQL, you can find information in this documentation


 

Please follow these steps to access MyLittleAdmin:

Via your Control Panel:

 

1. Log in to your Control Panel

 

2. Choose your hosting plan from the Subscription drop-down box (top-right)

ma1

 

3. Click on the Databases button in the tool box

ma2

 

4. If you do not have created a database yet:

 

  • Click on the Add New Database button in the tool bar  

cd

  • Fill out the database information as follow then click OK
    NB: Notice that the dataserver is mssql3.openhost.net.nz

dd5 

 

NB: To create a Database in the old plesk, please follow this tutorial video.

 

5. To access myLittleAdmin, click on the myLittleAdmin button next to your database name.

 ma3

Via your web browser:

1. Enter this URL in your browser: https://mlt.openhost.net.nz/mla/default.aspx

2. Connect to MyLittleAdmin:

  • Choose the server name
  • Login with the credentials of the database user

 

 

 


 

Please follow these steps to backup databases once in MyLittleAdmin:

 

1. Click on the Tools tab in the navigation panel

 

2. Click on the myLittleBackup link

 

3. In the openning page, click on the Backup databases link

 

4. Follow these instructions to backup your databases

 

 

 


 

Please follow these steps to restore your databases in MyLittleAdmin:

 

1. Click on the myLittleBackup link inside the tools tab

 

2. In the openning page, click on the Restore databases link

 

3. Follow the instructions to restore your databases

 

(1 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).