If your web server incorporates data processing applications or is designed to generate web pages dynamically, you will likely need a database for storing and retrieving data. You can either create a new database for your site or import the data from your previously backed up MySQL or PostgreSQL database.

To create a new database on your hosting account:

1. On your Home page, click the domain name you need.

2. Click Databases.

3. Click Add New Database.

4. Enter a name for the database.

5. Select the database type that you are going to use: MySQL or PostgreSQL. Click OK.

6. To set up database administrator's credentials, click Add New Database User.

7. Type a user name and a password that will be used for accessing the contents of the database.

8. Click OK.

To import an existing database:

1. On your Home page, click the domain name you need.

2. Click Databases.

3. Click Add New Database.

4. 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).

5. Select the database type that you are going to use: MySQL or PostgreSQL. Click OK.

6. To set up database administrator's credentials, click Add New Database User.

7. Type a user name and a password that will be used for accessing the contents of the database. Click OK.

8. 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.

9. Click on the Query window icon in the left frame.

10. Click the Import files tab.

11. Select the text file that contains the data and click Go.

12. 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).

If you collaborate with other people on managing a web site and wish to give them access to the database, you should create separate user accounts for them.

To create a database user account:

1. On your Home page, click the domain name you need.

2. Click the Databases icon in the Services group.

3. Click on a database name. A list of database users will open.

4. Click Add New Database User.

5. Type a user name and a password that will be used for accessing the contents of the database. Click OK.

To change password for a database user:

1. On your Home page, click the domain name you need.

2. Click the Databases icon in the Services group.

3. Click on a database name. A list of database users will open.

4. Click on the database user's name.

5. Type a new password and click OK.

To remove a database user account:

1. On your Home page, click the domain name you need.

2. Click the Databases icon in the Services group.

3. Click on a database name. A list of database users will open.

4. Select a check box corresponding to the user account that you wish to remove.

5. Click Remove Selected. Next, confirm removing and click OK.

To remove a database with its contents:

1. On your Home page, click the domain name you need.

2. Click the Databases icon in the Services group.

3. Select a check box corresponding to the database that you wish to remove.
If the required check box appears grayed out, this means that this database is used by a site application and you can remove it only by uninstalling the respective application.

4. Click Remove Selected.

5. Confirm removal and click OK.

Back up your domain (web site):

1. Click the domain name you need on your Home page.

2. Click the Backup icon in the Domain group.

3. Click the Backup Now icon in the Tools group.

4. Specify the backup file name and give a description to the backup file.

5. Click Next >>.

6. The backup will start and the progress will be shown.

• To update the information on the screen, click Refresh.
• To cancel the backup, click Cancel and confirm the cancellation by clicking OK.

7. Upon completion of the backup process you will be shown a window displaying the backup results, including errors, if they were encountered. Click OK.

The backup file will be saved to the repository under this web site hosting account, further accessible from the location Home > domain name > Backup.

Plesk Database Help Page 1

Plesk Database Help Page 2