Managing Database Servers

Operator: <db_server>

XML Schema: database_input.xsd, database_output.xsd

Plesk version: Plesk for MS Windows 7.0, Plesk 7.5.4 for Unix and later

API RPC version: 1.3.5.1 and higher

Plesk user: Plesk Administrator

Description

Managing database servers differs in Plesk for Unix and Plesk for Windows, basing on what databases are supported: Plesk for Windows supports MySQL and Microsoft SQL Server databases, Plesk for Unix supports MySQL and PostgreSQL databases.

 

A default database server is the one on which databases of a particular type are created by default, i.e., without specifying the parent database server. Only one default database server for each type of databases is available in Plesk.

Note: Use lower case for defining database servers types. In other case, the request might be incorrectly processed by Plesk server.

 

Supported operations

  • ADD creates a database server entry of the specified type, specifying the login and password of the database administrator.
  • SET updates properties of the specified database server.
  • DEL removes a database server entry. Only remote database servers can be specified. The default database server cannot be removed.
  • SET-DEFAULT sets a remote database server entry as default for its DBMS type. Only remote database servers can be specified.
  • GET-DEFAULT retrieves ID of a default database server.
  • GET retrieves the database server info by the server ID.
  • GET-SUPPORTED-TYPES get the DBMS types supported by the Plesk.
  • GET-LOCAL retrieves ID of a local database server.

Next in this section:

Adding Database Server

Changing Database Server Preferences

Detaching Database Servers

Setting Default Database Server

Retrieving Default Database Server Info

Retrieving Database Server Parameters

Retrieving Supported Types Of Databases

Retrieving Local Database Servers Info

 

Leave your feedback on this topic here

If you have questions or need support, please visit the Plesk forum or contact your hosting provider.
The comments below are for feedback on the documentation only. No timely answers or help will be provided.