--create-server

<host[:port]>

Adds a database server record to Plesk.

Requires -type, -admin, -passwd options.

To create the MySQL database server available at 192.0.2.33, with database server administrator's login admin and password setup:

database-server.exe --create-server 192.0.2.33 -type mysql -admin admin -passwd setup

--update-server

<host[:port]>

Changes configuration settings for the specified database server in Plesk.

To set password for administrator of a remote MySQL server available at 192.0.2.16:3838 to newdbapass:

database-server.exe --update-server 192.0.2.16:3838 -reset-passwd newdbapass

--remove-server

<host[:port]>

Removes a database server record from Plesk.

To remove the MySQL database server available at 192.0.2.33:

database-server.exe --remove-server 192.0.2.33

--set-default-server

<host[:port]>

Makes a database server primary among servers of the same type, meaning that if in Plesk a database is created for a domain, it is created on this, default DB server.

To set the MySQL database server available at 192.0.2.33 as default for newly created MySQL databases:

database-server.exe --set-default-server 192.0.2.33

--set-default-server-local

Assigns a local database server as the default server for the database type.

Requires -type option.

To set the local MySQL server as the default server for MySQL databases:

database-server.exe --set-default-server-local -type mysql

--list or -l

Displays the list of database servers registered in Plesk.

To see the list of database servers registered in Plesk:

database-server.exe --list

--xml-info or -xi

Displays the list of database servers registered in Plesk in the XML format.

To see the list of database servers registered in Plesk in the XML format:

database-server.exe --xml-info

--help or -h

Displays help on the use of the utility.

database-server.exe --help

or

database-server.exe -h

-type

mysql|mssql

Specifies a type of a database server.

Used only with the --create-server.

Required with --create-server.

To create the MySQL database server available at 192.0.2.33, with database server administrator's login admin and password setup:

database-server.exe --create-server 192.0.2.33 -type mysql -admin admin -passwd setup

-set

<host>:<port>

Specifies a database server host, port number, or a combination of the parameters.

To change the port on which the local MySQL database server listens to from default 3306 to 22222:

database-server.exe --update-server localhost:3306 -set 22308

-admin

<login_name>

Specifies a database server administrator's login name.

Required with --create-server.

To create the MySQL database server available at 192.0.2.33, with database server administrator's login admin and password setup:

database-server.exe --create-server 192.0.2.33 -type mysql -admin admin -passwd setup

-passwd

<password>

Specifies database server administrator's password.

Used only with --create-server.

Required with --create-server.

To create MySQL database server available at 192.0.2.33, with database server administrator's login admin and password setup:

database-server.exe --create-server 192.0.2.33 -type mysql -admin admin -passwd setup

-reset-passwd

<password>

Changes password of the database server administrator.

To change administrator's password to 123456 for the local Microsoft SQL Database server:

database-server.exe --update-server localhost -type mssql -reset-passwd 123456

-db-server-temp-backup-dir

The path to a physical folder on the remote server where the MS SQL server is located. The MS SQL server must be able to access this folder for reading and writing temporary backup files.

To set up database server backups:

database-server.exe -db-server-temp-backup-dir "C:\DirectoryPath" -db-server-network-backup-dir "\ServerName\DirectoryPath" -db-server-network-backup-usr backupuser -db-server-network-backup-pwd 1qazXSW@

-db-server-network-backup-dir

The path to the network share of the folder specified above. The network share should be mapped to that physical folder. Plesk will access the shared folder to download and upload backup files.

-db-server-network-backup-usr

<login>

The username of a network user created on the remote server. For example, ServerName\UserName. The user must have access to the shared folder specified above.

-db-server-network-backup-pwd

<passwd>

The network user's password.