Help Center > > API Reference> API v3 (Recommended)> Backup and Restoration> Restoring Tables to a Specified Point in Time (MySQL)

Restoring Tables to a Specified Point in Time (MySQL)

Updated at: Apr 22, 2020 GMT+08:00

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 primary/standby (1/2) and MySQL 8.0 instances.

URI

  • URI format

    POST

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

  • Example

    https://rds.ap-southeast-1.myhuaweicloud.com/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

    String

    Specifies the backup time point.

    database

    Yes

    String

    Specifies the database name.

    oldName

    Yes

    String

    Specifies the original table name before the restoration.

    newName

    Yes

    String

    Specifies the new table name after the restoration. The value is a string of 1 to 64 characters, containing only letters, digits, hyphens (-), and underscores (_). It cannot be left blank.

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

Response

  • Normal response

    None

Status Code

For details, see Status Codes.

Error Code

For details, see Error Codes.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel