mysqlbinlog 报错

Question

[root@docker-node1 mysql]# mysqlbinlog --no-defaults --stop-position=84555 --database=mc_orderdb mysql-bin.000014 > mc_order_diff.sql
WARNING: The option --database has been used. It may filter parts of transactions, but will include the GTIDs in any case. If you want to exclude or include transactions, you should use the options --exclude-gtids or --include-gtids, respectively, instead.

Answer 1

提问者 muke_007 2019-01-03 12:55:57

[root@docker-node1 mysql]# mysql --version

mysql  Ver 14.14 Distrib 5.7.22, for Linux (x86_64) using  EditLine wrapper

执行了这个操作，

[root@docker-node1 mysql]# mysqlbinlog --no-defaults --exclude-gtids --stop-position=84555 --database=mc_orderdb mysql-bin.000014 > mc_order_diff.sql

报错如下

ERROR: Malformed Gtid_set specification '--database=mc_orderdb'.

ERROR: Could not configure --exclude-gtids '--database=mc_orderdb'

Answer 2

sqlercn 2019-01-03 13:41:27

这是因为你启用了gitd才会有这个提示，一般来说直接忽略就可以了。

• 提问者 muke_007 #1

  忽略不行啊

• sqlercn 回复 提问者 muke_007 #2

  用 --skip-gtids 这个参数试一下