Website Databases in Windows Plesk Hosting
If site incorporates custom data processing applications or it is designed for generating websites dynamically. You may need a database for storing and retrieving data.
In Plesk, you will be able to do the following tasks:
1)Making the copy of databases.
2)View the connection information of hostname, username, database name.
3)Export and import database dumps and also backup databases as the part of the subscription backup.
4)To Link the database to any one of the websites on your subscriptions.
5)Will be able to create the manual database for your website.
6)Managing the database user accounts and also setting up of access rules.
7)Can check the database for any issues and repair the database.
8)Will be able to move the database to the different subscription.
9)Managing the data with external database management tools like phpMyAdmin.
You can perform these operations by selecting Websites & Domains tab and clicking on Databases.
Database Management Tools:
With the help of third-party database management tools with Plesk, you'll be able to edit tables in databases, run SQL queries and export and import data. These tools are accessible from the corresponding link in Websites & Domains tab > Databases. Eg: Plesk makes use of phpMyAdmin to manage the MySQL databases.
Accessing Databases with the ODBC:
If you want to deploy the application that works with the database with an Open Database Connectivity (ODBC) driver. You have to create a reliable ODBC data sources in the OS. In Plesk for Windows, you'll be able to add ODBC data sources for several supported ODBC drivers.
Active & Classic Lists:
As a default, the list of databases will be displayed within the Active List view mode. To change to the Classic List mode, you can use the icon right next to the search box. The important distinction between the modes is that in the Active List mode you'll be able to view statistics on the databases and also the name of the website to which the data will be assigned.
Automated Creation of Databases:
While installing the app from the application Catalog, all you needed is databases. A database user accounts are created automatically. Additionally, you'll be able to assign a manually created user account to a database created by the web app. For more details go to the web applications and select App Databases.