Share via


Retrieve All Databases on a Server (MySQL)

 

Applies To: Windows Azure Pack

Retrieves a list of all databases on the specified hosting server.

Request

Replace <ServiceMgmt> with your Service Management API endpoint address and <ServerId> with the identifier of the server.

Method

Request URI

HTTP version

GET

https://<ServiceMgmt>:30004/services/mysqlservers/hostingServers/<ServerId>/databases?skip=0&take=25

HTTP/1.1

URI Parameters

The following table describes the URI parameters.

URI Parameter

Description

skip

The number of items to bypass in the list, starting from the begging. The remaining items will be included in the list.

take

The number of items to retrieve, starting from the beginning of the list. The remaining items will be excluded from the list.

Request Headers

The following table describes required and optional request headers.

Request header

Description

Authorization: Bearer

Required. The authorization bearer token.

x-ms-principal-id

Required. The principal identifier.

x-ms-client-request-id

Optional. The client request identifier.

x-ms-client-session-id

Optional. The client session identifier.

x-ms-principal-liveid

Optional. The principal Live identifier.

Request Body

None.

Response

The response includes an HTTP status code, a set of response headers, and a response body.

Status Code

A successful operation returns status code 200 (OK).

Response Headers

The response for this operation includes standard HTTP headers. All standard headers conform to the HTTP/1.1 protocol specification.

Response Body

The following table describes the key elements of the response body:

Element name

Description

SqlDatabase

The retrieved list of databases. For more information, see MySqlDatabase (Object).

Example

The following code example shows a Retrieve All Databases on a Hosting Server request.

GET https://<ServiceMgmt>:30004/services/mysqlservers/hostingServers/<ServerId>/databases?skip=0&take=25 HTTP/1.1
x-ms-version: 2012-03-01
Accept: application/json
Authorization: Bearer <Token>
x-ms-client-request-id: 5917471f-f9d9-48b3-952d-9679335f96fe-2013-08-28 23:45:45Z
x-ms-client-session-id: aa1ca0e4-94b9-4db6-97ab-e1ed667173d7
x-ms-principal-id: <SERVICEMGMT>%5cAdministrator
Accept-Language: es-ES
Host: <ServiceMgmt>:30004

The following code example shows a Retrieve All Databases on a Hosting Server response.

{
  "items": [

  ],
  "filteredTotalCount": 0,
  "totalCount": 0
}

See Also

MySQL Resource Provider Hosting Server Interfaces