Updated on 2022-08-16 GMT+08:00

Restoring Tables to a Specified Point in Time (MySQL)

Function

To ensure data integrity and reduce impact on the original instance performance, the system restores the full and incremental data at the selected time point to a temporary DB instance, automatically exports the tables to be restored, and then restores the tables to the original DB instance.

This operation will generate restored tables on the original DB instance. Ensure that the original DB instance has sufficient storage capacity.

Constraints

  • This API is supported for MySQL only.
  • This API is not supported for MySQL 8.0 DB instances.

URI

  • URI format

    POST

    https://{Endpoint}/v3/{project_id}/instances/{instance_id}/restore/tables

  • Example

    https://rds.my-kualalumpur-1.alphaedge.tmone.com.my/v3/0483b6b16e954cb88930a360d2c4e663/instances/dsfae23fsfdsae3435in01/restore/tables

  • Parameter description
    Table 1 Parameter description

    Name

    Mandatory

    Description

    project_id

    Yes

    Specifies the project ID of a tenant in a region.

    For details about how to obtain the project ID, see Obtaining a Project ID.

    instance_id

    Yes

    Specifies the DB instance ID.

Request

  • Parameter description
    Table 2 Parameter description

    Name

    Mandatory

    Type

    Description

    restoreTime

    Yes

    Long

    Specifies the backup time point.

    restoreTables

    Yes

    Array of objects

    Database information. For details, see Table 3.

    Table 3 restoreTables field data structure description

    Name

    Mandatory

    Type

    Description

    database

    Yes

    String

    Specifies the database name.

    tables

    Yes

    Array of objects

    Specifies the table information. For details, see Table 4.

    Table 4 tables field data structure description

    Name

    Mandatory

    Type

    Description

    oldName

    Yes

    String

    Specifies the original table name before the restoration.

    newName

    Yes

    String

    Specifies the table name after the restoration.

  • Request example
    {
        "restoreTime": 1583720991838,
        "restoreTables": [
            {
                "database": "restoretest",
                "tables": [
                    {
                        "oldName": "test",
                        "newName": "test_1583720991838"
                    }
                ]
            }
        ]
    }

Response

  • Normal response

    Name

    Type

    Description

    jobId

    String

    Indicates the task ID.

  • Example normal response
    {
        "jobId":"7b55d6ca-dc8e-4844-a9da-6c53a1506db3"
    }
  • Abnormal response

    For details, see Abnormal Request Results.

Status Code

For details, see Status Codes.

Error Code

For details, see Error Codes.