If your website incorporates custom data processing applications or is designed to generate web pages dynamically, you will probably need a database for storing and retrieving data.
In Plesk, you can do the following:
- Manually create a database for your site.
- Make a database copy.
- Manage database user accounts and set up access rules.
- View connection information (host name, database name, username).
- Check a database for issues and repair the database.
- Export and import database dumps or backup databases as part of a subscription backup.
- Move a database to another subscription.
- Link a database to one of websites on your subscription.
- Manage data with external database management tools, such as phpMyAdmin.
These operations are available in Websites & Domains tab > Databases.
Active and Classic Lists¶
By default, the list of databases is displayed in the Active List view mode. To switch to the Classic List mode, use the icon next to the search box. The main difference between the modes is that in the Active List mode you can view statistics on the database and the name of the website to which the database is assigned.
Database Management Tools¶
With the third-party database management tools supplied with Plesk, you can edit tables in databases, export and import data, and run SQL queries. These tools are available under the corresponding link in Websites & Domains tab > Databases. For example, Plesk uses phpMyAdmin to manage MySQL databases.
Automatic Creation of Databases¶
When you install an app from the Application Catalog, all required databases and database user accounts are created automatically. Alternatively, you can assign a manually created user account to a database created by a web app. For more information, see the section Web Applications > App Databases.
Accessing Databases with ODBC¶
If you wish to deploy an application which works with a database through an Open Database Connectivity (ODBC) driver, you will need to create an appropriate ODBC data source in the operating system. In Plesk for Windows you can add ODBC data sources for a number of supported ODBC drivers. For more information, see Accessing Databases with ODBC (Windows).