Exporting Binlogs
Function
This API is used to export binlog parsing results.
Authorization Information
Each account has permissions to call all APIs, but IAM users must have the required permissions specifically assigned.
- If you are using role/policy-based authorization, see the required permissions in Permissions Policies and Supported Actions.
- 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
das:clouddba:createBinlogAnalysisTask
Write
Instance
-
-
-
URI
POST /v3/{project_id}/connections/{connection_id}/binlog-parse/export
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| project_id | Yes | String | Definition Project ID of a tenant in a region. To obtain this value, see Obtaining a Project ID. Constraints N/A Range The value can contain 32 characters. Only letters and digits are supported. Default Value N/A |
| connection_id | Yes | String | Definition Connection ID established between a database account and the database. The database user ID is created using the API in Creating an Instance Connection. Constraints N/A Range The value is a UUID containing 36 characters. Only letters, digits, and hyphens (-) are allowed. Default Value N/A |
Request Parameters
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| bucket_name | Yes | String | Definition OBS bucket name Constraints N/A Range N/A Default Value N/A |
| info | No | Table 3 object | Definition Export filter Constraints N/A Range N/A Default Value N/A |
| task_id | Yes | Long | Definition ID of a binlog parsing task Constraints N/A Range N/A Default Value N/A |
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| db_names | No | Array of strings | Definition Database names Constraints N/A |
| tb_names | No | Array of strings | Definition Table names Constraints N/A |
| file_names | No | Array of strings | Definition File names Constraints N/A |
| start_time | No | Long | Definition Start time Constraints N/A Range N/A Default Value N/A |
| end_time | No | Long | Definition End time Constraints N/A Range N/A Default Value N/A |
| type_list | No | Array of strings | Definition SQL types
Constraints N/A |
| column_list | No | Array of Table 4 objects | Definition Columns Constraints N/A |
| parse_double_insert | No | Boolean | Definition Whether to export an UPDATE statement as two INSERT statements Constraints N/A Range
Default Value N/A |
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| column_name | No | String | Definition Column name Constraints N/A Range N/A Default Value N/A |
| column_value | No | String | Definition Column value Constraints N/A Range N/A Default Value N/A |
Response Parameters
None
Example Requests
POST https://das.cn-north-1.myhuaweicloud.com/v3/054e292c9880d4992f02c0196d3ea468/connections/179e525e-0e9c-4dcc-9dd7-ee2f36121e23/binlog-parse/export
{
"task_id": 1162,
"bucket_name": "5257",
"info": {
"db_names": [],
"tb_names": [],
"start_time": null,
"end_time": null,
"type_list": ["insert", "update", "delete", "ddl"],
"column_list": [],
"parse_double_insert": false
}
} Example Responses
Status code: 200
Success.
9527
Status Codes
| Status Code | Description |
|---|---|
| 200 | Success. |
| 400 | Client error. |
| 500 | Server error. |
Error Codes
See Error Codes.
What is your overall rating for this page?
Thank 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