Querying Tables That Can Be Restored to a Specified Point in Time

Function

This API is used to query tables that can be restored to a specified point in time.

URI

URI format
POST /v3/{project_id}/{engine}/instances/history/tables

Parameter description

**Table 1** Parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Explanation: Project ID of a tenant in a region. For details about how to obtain the project ID, see Obtaining a Project ID. Constraints: N/A Value range: N/A Default value: N/A
engine	Yes	String	Explanation: DB engine. Constraints: N/A Value range: mysql (case-insensitive) Default value: N/A

Request

Parameter description

**Table 2** Parameters
Parameter	Mandatory	Type	Description
instance_ids	Yes	Array of strings	Explanation: Instance IDs. Constraints: N/A
restore_time	Yes	Long	Explanation: Restoration time point. Constraints: N/A Value range: N/A Default value: N/A
database_name_like	No	String	Explanation: Database name, which can be used for fuzzy search. Constraints: N/A Value range: The value can contain 1 to 64 characters. Only letters, digits, dollar signs ($), hyphens (-), periods (.), and underscores (_) are allowed. Default value: N/A
table_name_like	No	String	Explanation: Table name, which can be used for fuzzy search. Constraints: N/A Value range: The value cannot contain the characters ' " \ /. Default value: N/A
instance_name_like	No	String	Explanation: Instance name, which can be used for fuzzy query. Constraints: N/A Value range: The value can contain 1 to 64 characters. Only letters, digits, hyphens (-), periods (.), and underscores (_) are allowed. Default value: N/A

Example request

POST https://{Endpoint}/v3/4879de6859e345c780f1a22d8bc6f229/mysql/instances/history/tables
{ 
  "instance_ids" : [ "e38d120bb5a640519fb2a1613140afd9in01" ], 
  "restore_time" : 1688554112000, 
  "database_name_like" : "", 
  "table_name_like" : "", 
  "instance_name_like" : "" 
}

Response

Normal response

**Table 3** Parameters
Parameter	Type	Description
table_limit	Integer	Explanation: Maximum number of tables that can be restored. Value range: N/A
instances	Array of objects	Explanation: Instance information. For details, see Table 4.

**Table 4** instances field data structure description
Parameter	Type	Description
id	String	Explanation: Instance ID. Value range: N/A
name	String	Explanation: Instance name. Value range: N/A
total_tables	Integer	Explanation: Number of tables that can be restored. Value range: N/A
databases	Array of objects	Explanation: Database information. For details, see Table 5.

**Table 5** database field data structure description
Parameter	Type	Description
name	String	Explanation: Schema name. Value range: N/A
total_tables	Integer	Explanation: Number of tables that can be restored. Value range: N/A
tables	Array of objects	Explanation: Table information. For details, see Table 6.

**Table 6** tables field data structure description
Parameter	Type	Description
name	String	Explanation: Table name. Value range: N/A

Example normal response

{
    "instances": [
        {
            "id": "e38d120bb5a640519fb2a1613140afd9in01",
            "name": "rds-abc",
            "total_tables": 1,
            "databases": [
                {
                    "name": "test",
                    "total_tables": 1,
                    "tables": [
                        {
                            "name": "t1"
                        }
                    ]
                }
            ]
        }
    ],
    "table_limit": 2000
}