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 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 API will be unavailable on September 14, 2025. You are advised to switch workloads to the new API (Restoring Tables to a Specified Point in Time (RDS for MySQL)) before then.
This operation will generate restored tables on the original DB instance. Ensure that the original DB instance has sufficient storage capacity.
- Before calling an API, you need to understand the API in Authentication.
Constraints
- This API is supported for RDS for MySQL only.
- This API is not supported for RDS for MySQL 8.0 DB instances.
URI
- URI format
POST /v3/{project_id}/instances/{instance_id}/restore/tables
- Parameter description
Table 1 Parameter description Name
Mandatory
Description
project_id
Yes
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
Name |
Mandatory |
Type |
Description |
---|---|---|---|
restoreTime |
Yes |
Long |
Backup time point. |
restoreTables |
Yes |
Array of objects |
Database information. For details, see Table 3. |
is_fast_restore |
No |
Boolean |
Whether to use fast restoration. The value can be true or false.
|
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. |
Example Request
POST https://{endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/instances/dsfae23fsfdsae3435in01/restore/tables { "restoreTime": 1583720991838, "restoreTables": [ { "database": "restoretest", "tables": [ { "oldName": "test", "newName": "test_1583720991838" } ] } ] }
Response
- Normal response
Table 5 Response body parameters 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
- Normal
- Abnormal
For details, see Status Codes.
Error Code
For details, see Error Codes.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot