getCloudMysqlDatabaseList

Available in VPC

Get the list of Cloud DB for MySQL instance databases.

Syntax

The getCloudMysqlDatabaseList syntax is as follows:

./ncloud vmysql getCloudMysqlDatabaseList \
    --cloudMysqlInstanceNo <instance-no> \
    --pageNo <page-no> \
    --pageSize <page-size> \
    [--regionCode <KR|SGN|JPN>] \
    [--output <json|xml>]

Options

This section describes the options available when running getCloudMysqlDatabaseList.

Required options

The following options are required for getCloudMysqlDatabaseList.

Options	Type	Required	Description
`--cloudMysqlInstanceNo`	String	Required	Cloud DB for MySQL instance number See getCloudMysqlInstanceList.
`--pageNo`	Integer	Required	Page number `0`-N
`--pageSize`	Integer	Required	Number of items per page `1`-N

Common options

For information about the options common to all vmysql subcommands, see Cloud DB for MySQL (VPC) options.

Examples

If the request to list Cloud DB for MySQL databases is successful, the names of each database are returned.

Command

The command example is as follows:

./ncloud vmysql getCloudMysqlDatabaseList \
    --cloudMysqlInstanceNo 12345678 \
    --pageNo 0 \
    --pageSize 10 \
    --regionCode KR \
    --output json

Output

The output example is as follows:

{
  "getCloudMysqlDatabaseListResponse": {
    "totalRows": 3,
    "cloudMysqlDatabaseList": [
      {
        "databaseName": "mysql_test1"
      },
      {
        "databaseName": "mysql_test2"
      },
      {
        "databaseName": "testdb"
      }
    ],
    "requestId": "b2c3d4e5-f6a7-8901-bcde-f23456789012",
    "returnCode": "0",
    "returnMessage": "success"
  }
}