mysqlbinlog 报错
来源：4-9 指定时点的恢复
muke_007
2019-01-03
[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.
2回答
-
muke_007
提问者
2019-01-03
[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'
10 -
sqlercn
2019-01-03
这是因为你启用了gitd才会有这个提示，一般来说直接忽略就可以了。
022019-01-04
相似问题