Updated on 2026-08-25 GMT+08:00

Restoring Tables to a Specified Point in Time (RDS for MySQL)

Function

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

Before calling this API, learn how to authenticate it.
Before calling this API, learn about the request header parameters.

Authorization Information

Each account has all the permissions required to call all APIs, but IAM users must be assigned the required permissions.

If you are using role/policy-based authorization, see Permissions and Supported Actions for details on the required permissions.
If you are using identity policy-based authorization, the following identity policy-based permissions are required.

Action	Access Level	Resource Type (*: required)	Condition Key	Alias	Dependencies
rds:instance:tableRestore	write	-	-	-	-

Constraints

This API is available to RDS for MySQL only.
This operation will generate restored tables on the original DB instance. Ensure that the original DB instance has sufficient storage capacity.

URI

URI format
POST /v3.1/{project_id}/instances/{instance_id}/restore/tables

Parameter description

**Table 1** Parameters
Parameter	Mandatory	Description
project_id	Yes	Definition Project ID of a tenant in a region. Constraints The value cannot be empty. Range To obtain the value, see Obtaining a Project ID. Default Value N/A
instance_id	Yes	Definition Instance ID. Constraints The value cannot be empty. Range You can obtain the value of this parameter from id in Table 4 by calling the API for querying DB instances. Default Value N/A

Request

**Table 2** Parameters
Parameter	Mandatory	Type	Description
restore_time	Yes	Long	Definition Restoration timestamp, in milliseconds. Constraints N/A Range N/A Default Value N/A
restore_tables	Yes	Array of objects	Definition Table information. For details, see Table 3. Constraints N/A
is_fast_restore	No	Boolean	Definition Whether to use fast restoration. Constraints To set this parameter, check whether fast restoration is supported by referring to Checking Whether Fast Restoration Can Be Used for Restoring Databases or Tables (RDS for MySQL). If fast restoration is supported, but there are XA transactions in the DB instance, set this parameter to false to prevent data loss. If this parameter is not specified, the system determines whether to use fast restoration based on the query result of Checking Whether Fast Restoration Can Be Used for Restoring Databases or Tables (RDS for MySQL). If fast restoration is supported, but there are XA transactions in the DB instance, set this parameter to false. Range true: Fast restoration is used. false: Fast restoration is not used. Default Value N/A

**Table 3** Data structure of the restore_tables field
Parameter	Mandatory	Type	Description
database	Yes	String	Definition Database name. Constraints N/A Range You can obtain the value of this parameter from name in Table 5 by calling the API for querying databases that can be restored to a specified point in time. Default Value N/A
tables	Yes	Array of objects	Definition Table information. For details, see Table 4. Constraints N/A

**Table 4** Data structure of the tables field
Parameter	Mandatory	Type	Description
old_name	Yes	String	Definition Original table name before the restoration. Constraints N/A Range You can obtain the value using either of the following methods: Method 1: Log in to the DB instance to obtain the table name. Method 2: Obtain the table name on the page for restoring databases or tables to a point in time. Default Value N/A
new_name	Yes	String	Definition Table name after the restoration. Constraints N/A Range You can customize the new table name. Default Value N/A

Example Request

Restore table data to a specific point in time.

POST https://{endpoint}/v3.1/054e292c9880d4992f02c0196d3ea468/instances/d8e6ca5a624745bcb546a227aa3ae1cfin01/restore/tables 

{ 
   "restore_time" : 1689859468000, 
   "restore_tables" : [ { 
     "database" : "database", 
     "tables" : [ { 
       "old_name" : "oldTable", 
       "new_name" : "newTable" 
     } ] 
   } ] 
 }

Response

Normal response

Table 5 Response body parameters

Parameter

Type

Description

job_id

String

Definition

Task ID.

Range

N/A

**Table 5** Response body parameters
Parameter	Type	Description
job_id	String	Definition Task ID. Range N/A

Example normal response

{ 
  "job_id" : "04efe8e2-9255-44ae-a98b-d87cae411890" 
}

Abnormal response
For details, see Abnormal Response Results.

Status Code

Normal
200
Abnormal
For details, see Status Codes.

Error Code

For details, see Error Codes.

Parent topic: API v3.1