Creating or Importing a Database
To create a new database on a hosting account:
- Click the Domains shortcut in the navigation pane.
- Click the required domain name in the list.
- Click
Databases. - Click
Add New Database. - 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).
- Select the database type that you are going to use: MySQL or PostgreSQL. Click OK.
- To set up database administrator's credentials, click
Add New Database User. - Type a user name and a password that will be used for accessing the contents of the database.
- Click OK.
To import an existing database:
- Click the Domains shortcut in the navigation pane.
- Click the required domain name in the list.
- Click
Databases. - Click
Add New Database. - 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).
- Select the database type that you are going to use: MySQL or PostgreSQL. Click OK.
- To set up database administrator's credentials, click
Add New Database User. - Type a user name and a password that will be used for accessing the contents of the database. Click OK.
- Click the
DB WebAdmin icon in the Tools group. An interface to phpMyAdmin (or phpPgAdmin) database management tool will open in a separate browser window. - Click on the Query window icon in the left frame.
- Click the Import files tab.
- Select the text file that contains the data and click Go.
- Click the Insert data from a text file link.
To manage your databases and their contents, use your favorite MySQL or PostgreSQL client or the web based database management tool accessible from Plesk control panel (Domains > domain name > Databases > Database name > DB WebAdmin).