Query Backup Data Library

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

    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":[]
            }
        ]
    }

    Was this page helpful?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help