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 comments on this page

Leave your feedback or question on this documentation topic below. For technical assistance, contact your hosting service provider or submit a request to Plesk support. Suggest new features for Plesk here. Discuss general questions on the Plesk forum. All offtopic comments will be removed.