Update a MySQL Database

 

Applies To: Windows Azure Pack

Updates the specified MySQL database.

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

PUT

https://<TenantAPI>:30005/<SubscriptionId>/services/mysqlservers/databases/<DatabaseName>

HTTP/1.1

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.

The following table describes the elements of the request body.

Element name

Description

MySqlDatabase

The database to update. For more information, see MySqlDatabase (Object).

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

A successful operation returns status code 200 (OK).

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

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

Element name

Description

SqlDatabase

The updated database. For more information, see SqlDatabase (Object).

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

PUT 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
Content-Type: application/json; charset=utf-8
Host: pt-cspod21:30005
Content-Length: 519
Expect: 100-continue
{
  "Name": "NewDatabase",
  "MySqlServerName": "<computer>",
  "MySqlServerId": "lxbn7i",
  "SubscriptionId": "9599bfe1-7a75-47ad-836b-97b80ea86103",
  "ConnectionString": "Server=pt-cspod21;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": "pass@word1",
  "Quota": "1024",
  "AccountAdminId": null
}

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

{
  "Name": "NewDatabase",
  "MySqlServerName": "<computer>",
  "MySqlServerId": "lxbn7i",
  "SubscriptionId": "9599bfe1-7a75-47ad-836b-97b80ea86103",
  "ConnectionString": "Server=pt-cspod21;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
}

Show: