Hot Lines: +92 321 8488 463 & +1 786 2179 794
Portal HomeClient AreaAnnouncementsKnowledgebaseSupport TicketsDownloads

Knowledgebase
You are here: Portal Home > Knowledgebase > PLESK > How to create or import databases - Windows

How to create or import databases - Windows

To create a new database on your hosting account:

  1. On your Home page, click Databases.
  2. Click Add New Database.
  3. Enter a name for the database.

    We recommend that you choose a name that starts with a Latin alphabet symbol and comprises only alphanumeric and underscore symbols (up to 64 symbols).

  4. Select the database type that you are going to use: MySQL or Microsoft SQL Server. Click OK.
  5. To set up database administrator's credentials, click btn new user Add New Database User.
  6. Type a user name and a password that will be used for accessing the contents of the database.
  7. Click OK.

To import an existing database:

  1. On your Home page, click Databases.
  2. Click Add New Database.
  3. Enter a name for the database.

    We recommend that you choose a name that starts with a Latin alphabet symbol and comprises only alphanumeric and underscore symbols (up to 64 symbols).

  4. Select the database type that you are going to use: MySQL or Microsoft SQL Server. Click OK.
  5. To set up database administrator's credentials, click btn new user Add New Database User.
  6. Type a user name and a password that will be used for accessing the contents of the database. Click OK.
  7. Click WebAdmin in the Tools group.

    An interface to phpMyAdmin (or phpMSAdmin) database management tool will open in a separate browser window.

  8. Click Query window in the left frame.
  9. Click the Import files tab.
  10. Select the text file that contains the data and click Go.
  11. Click the Insert data from a text file link.

To manage your databases and their contents, use your favorite MySQL or Microsoft SQL client or the web based database management tool accessible from Plesk control panel (Home > Databases > Database name > WebAdmin).



Was this answer helpful?

Add to Favourites
Print this Article

Also Read
Why can't I upload files? - Windows (Views: 180)
How to create email accounts - Windows (Views: 235)
How to change SMTP port number - Windows (Views: 236)
How to password protect a folder - Windows (Views: 200)
E-mail doesn't seem to work - Windows (Views: 185)

Powered by WHMCompleteSolution


Language:

Copyright © 2011 NavicoSoft , All rights reserved.