Retrieve a MySQL Database

Article
08/24/2015

Applies To: Windows Azure Pack

Retrieves a MySQL database by name.

Request

Replace <TenantAPI> with your Service Management API endpoint address, <SubscriptionId> with the tenant subscription identifier, and <DatabaseName> with the name of the database to retrieve.

Method	Request URI	HTTP version
GET	https://<TenantAPI>:30005/<SubscriptionId>/services/mysqlservers/databases/<DatabaseName>	HTTP/1.1

URI Parameters

None.

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 204 (No content).

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
MySqlDatabase	The new plan. For more information, see MySqlDatabase (Object).

Example

The following code example shows a Retrieve a MySQL Database request.

GET https://<TenantAPI>:30005/<SubscriptionId>/services/mysqlservers/databases/<DatabaseName> HTTP/1.1
x-ms-version: 2012-03-01
Accept: application/json
Authorization: Bearer <Token>
x-ms-client-request-id: 37b71167-5e1b-4c35-8e4d-6adc86b9b811-2013-08-28 23:49:19Z
x-ms-client-session-id: e046372b-5230-47b9-b98e-af0d9d627f78
x-ms-principal-id: person%40contoso.com
Accept-Language: es-ES
Host: <TenantAPI>:30005

The following code example shows a Retrieve a MySQL Database response.

{
  "Name": "NewDatabase",
  "MySqlServerName": "<computer>",
  "MySqlServerId": "lxbn7i",
  "SubscriptionId": "9599bfe1-7a75-47ad-836b-97b80ea86103",
  "ConnectionString": "Server=<computer>;Database=NewDatabase;User Id=newAdmin;Password=<<Aqu\u00ed-va-la-contrase\u00f1a-de-su-base-de-datos>>",
  "Edition": "Default",
  "MaxSizeMB": 1024,
  "Collation": "latin1_swedish_ci",
  "CreationDate": "0001-01-01T00:00:00+00:00",
  "ModifiedDate": "0001-01-01T00:00:00+00:00",
  "Status": "1",
  "AdminLogon": "newAdmin",
  "Password": "",
  "Quota": "1024",
  "AccountAdminId": null
}

Share via