Query Backup Data Library

Last updated: 2017-12-14 11:33:13

PDF

1. API Description

This API (GetBackupDatabaseTableList) is used to query the database table of backup data.
Domain for API request: cdb.api.qcloud.com

2. Input Parameters

The following request parameter list only provides API request parameters. Common request parameters are also needed when API is called. For more information, please refer to Common Request Parameters. The Action field for this API is GetBackupDatabaseTableList.

Parameter Name Required Type Description
cdbInstanceId Yes String Instance ID, such as: cdb-c1nl9rpv. It is identical to the instance ID displayed in the Cloud Database console page and can be obtained using API Query List of Instances. Its value equals to the uInstanceId field value in the output parameter.
date Yes String Backup time, with the time format: 2015-11-05 02:18:23. The Query Backups and Logs API can be used to obtain backup time, with type value passing coldbackup

3. Output Parameters

Parameter Name Type Description
code Int Common error code; 0: Succeeded; other values: Failed. For more information, please refer to Common Error Codes on the Error Code page.
message String Module error message description depending on API.
codeDesc String Error code description
data Array Database table data

The data parameter is constructed as follows:

Parameter Name Type Description
dbname String Database name
tableList Array Table name in database

4. Error Codes

The following error codes only include the business logic error codes for this API.

Error Code Error Message Error Description
9003 InvalidParameter Incorrect parameter
9006 InternalError Database internal error

5. Example

Input

https://cdb.api.qcloud.com/v2/index.php?Action=GetBackupDatabaseTableList
&<Common request parameters>
&cdbInstanceId=cdb-c1nl9rpv
&date=2016-07-06 01:04:54

Output

{
    "code":"0",
    "message":"",
    "codeDesc":"Success",
    "data":[
        {
            "dbname":"mysql",
            "tableList":[
                "general_log",
                "slow_log",
                "columns_priv",
                "db"
            ]
        },
        {
            "dbname":"test1",
            "tableList":[]
        }
    ]
}