---
title: "导入 binlog"
method: POST
path: "/mysql/recover-binlog"
tags: ["mysql"]
---

# 导入 binlog

`POST /mysql/recover-binlog`

通过 `mysqlbinlog xxx | mysql` 导入 binlog

## Request body

- DbmServicesMysqlDbToolsDbactuatorPkgComponentsMysqlRestoreRecoverBinlogComp
  - `extend` DbmServicesMysqlDbToolsDbactuatorPkgComponentsMysqlRestoreRecoverBinlog
    - `binlog_dir` string, required — 恢复时 binlog 存放目录，一般是下载目录
    - `binlog_files` string[], required — binlog列表
    - `binlog_start_file` string — 指定要开始应用的第 1 个 binlog。如果指定，一般要设置 start_pos，如果不指定则使用 start_time
    - `parse_concurrency` integer — 解析的并发度，默认 1
    - `parse_only` boolean — 仅解析 binlog，不做导入
    - `quick_mode` boolean — 如果启用 quick_mode，解析 binlog 时根据 filter databases 等选项过滤 row event，对 query event 会全部保留 。需要 mysqlbinlog 工具支持 --tables 选项，可以指定参数的 tools 当 quick_mode=false 时，recover_opt 里的 databases 等选项无效，会应用全部 binlog
    - `recover_opt` DbmServicesMysqlDbToolsDbactuatorPkgComponentsMysqlRestoreMySQLBinlogUtil, required
      - `databases` string[] — row event 解析指定 databases
      - `databases_ignore` string[] — row event 解析指定 忽略 databases
      - `filter_statement_match_error` string — 匹配字符串成功，则解析 binlog 报错
      - `filter_statement_match_ignore` string — 匹配字符串成功，则忽略语句，加入注释中
      - `filter_statement_match_ignore_force` string — 匹配字符串成功，强制忽略语句，加入注释中。当与 filter_statement_match_error 都匹配时，ignore_force会优先生效 默认 infodba_schema
      - `flashback` boolean — 是否启用 flashback
      - `idempotent_mode` boolean — 是否开启幂等模式, mysql --slave-exec-mode=idempotent or mysqlbinlog --idempotent
      - `mysql_client_opt` DbmServicesMysqlDbToolsDbactuatorPkgComponentsMysqlRestoreMySQLClientOpt
        - `binary_mode` boolean — 是否启用 --binary-mode
        - `max_allowed_packet` integer
      - `not_write_binlog` boolean — 导入时是否记录 binlog, mysql sql_log_bin=0 or mysqlbinlog --disable-log-bin. true表示不写
      - `query_event_handler` 'keep' | 'ignore' | 'safe' | 'error' — query event 默认处理策略。keep:保留解析出的query event 语句, ignore:注释(丢弃)该 query event, error:认为是不接受的语句，报错 默认 keep
      - `rewrite_db` string — --rewrite_db="db1->xx_db1,db2->xx_db2"
      - `start_pos` integer — --start-position
      - `start_time` string — --start-datetime
      - `stop_pos` integer — --stop-position
      - `stop_time` string — --stop-datetime
      - `tables` string[] — row event 解析指定 tables
      - `tables_ignore` string[] — row event 解析指定 忽略 tables
    - `source_binlog_format` '' | 'ROW' | 'STATEMENT' | 'MIXED'
    - `tgt_instance` DbmServicesMysqlDbToolsDbactuatorPkgNativeInsObject, required
      - `charset` string — 连接字符集
      - `host` string — 当前实例的主机地址
      - `options` string — 其它选项
      - `port` integer — 当前实例的端口
      - `pwd` string — 连接当前实例的User Pwd
      - `socket` string — 连接socket
      - `user` string — 连接当前实例的User
    - `tools` object — 外部指定工具路径
    - `work_dir` string, required — binlog 解析所在目录，存放运行日志
    - `work_id` string
  - `general` DbmServicesMysqlDbToolsDbactuatorPkgComponentsGeneralParam
    - `runtime_account` DbmServicesMysqlDbToolsDbactuatorPkgComponentsRuntimeAccountParam
      - `admin_pwd` string — mysql admin 密码，环境变量 GENERAL_ACCOUNT_admin_pwd
      - `admin_user` string — mysql admin 账户，环境变量 GENERAL_ACCOUNT_admin_user
      - `backup_pwd` string — dbbackup pwd
      - `backup_user` string — dbbackup user
      - `monitor_access_all_pwd` string — mysql monitor@% 密码
      - `monitor_access_all_user` string — mysql monitor@%
      - `monitor_pwd` string — mysql monitor 密码，环境变量 GENERAL_ACCOUNT_monitor_pwd
      - `monitor_user` string — mysql monitor 账户，环境变量 GENERAL_ACCOUNT_monitor_user
      - `proxy_admin_pwd` string — proxy admin pwd
      - `proxy_admin_user` string — proxy admin user
      - `repl_pwd` string — repl pwd, 环境变量 GENERAL_ACCOUNT_repl_pwd
      - `repl_user` string — repl user, 环境变量 GENERAL_ACCOUNT_repl_user
      - `tdbctl_pwd` string
      - `tdbctl_user` string
      - `yw_pwd` string — yw pwd
      - `yw_user` string — yw user
    - `runtime_extend` DbmServicesMysqlDbToolsDbactuatorPkgComponentsRuntimeExtend
      - `mysql_sys_users` string[]

---

[API](https://skmtc.net/tencentblueking/apis/dbactuator-api.md) · [All operations](https://skmtc.net/tencentblueking/apis/dbactuator-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/tencentblueking/dbactuator-api/versions/dc22dd49fd50/schema)