Creating or Importing a Database
To create a new database on your hosting account:
- On your Home page, click the domain name you need.
- 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.
- Select the database server of the selected type from the list. 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:
- On your Home page, click the domain name you need.
- 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.
- Select the database server of the selected type from the list. 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 (Home > domain name > Databases > Database name > DB WebAdmin).