Use the del operation to detach database servers from Plesk. This option is available only for remote database servers. Default database servers cannot be removed using this operation. You can detach multiple database servers in a single packet.
A request XML packet detaching a database server from Plesk includes the del operation node:
<packet>
<db_server>
<del>
...
</del>
</db_server>
</packet>
The del node has the following graphical representation:
database_input.xsd
).Remarks
You can detach multiple database servers from Plesk in a single packet. Add as many id parameters as the number of database servers which are to be detached.
<db_server>
<del>
<filter>
<id>...</id>
...
<id>...</id>
</filter>
</del>
</db_server>
The del node of the output XML packet is structured as follows:
database_output.xsd
).
This packet detaches the database server specified by ID 5 from Plesk.
<packet>
<db_server>
<del>
<filter>
<id>5</id>
</filter>
</del>
</db_server>
</packet>
Response:
<packet>
<db_server>
<del>
<result>
<status>ok</status>
<id>5</id>
</result>
</del>
</db_server>
</packet>
If the database server was a default database server, the response from the server looks as follows:
<packet>
<db_server>
<del>
<result>
<status>error</status>
<errcode>1023</errcode>
<errtext>The default database server cannot be deleted.</errtext>
<id>5</id>
</result>
</del>
</db_server>
</packet>
If the database server with ID 5 was not found on the server, the response looks as follows:
<packet>
<db_server>
<del>
<result>
<status>error</status>
<errcode>1013</errcode>
<errtext>Database server does not exist.</errtext>
<id>5</id>
</result>
</del>
</db_server>
</packet>
This packet detaches all remote database servers from Plesk.
<packet>
<db_server>
<del>
<filter/>
</del>
</db_server>
</packet>
Reponse:
<packet>
<db_server>
<del>
<result>
<status>ok</status>
<id>5</id>
</result>
<result>
<status>ok</status>
<id>6</id>
</result>
<result>
<status>ok</status>
<id>7</id>
</result>
</del>
</db_server>
</packet>