Updated on 2026-08-25 GMT+08:00

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

Table 1 URI parameters

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

Table 2 Request body 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

Table 3 ExportCondition

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

  • insert
  • update
  • delete
  • ddl

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

  • true
  • false

Default Value

N/A

Table 4 ColumnInfo

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.