MyFlash icon indicating copy to clipboard operation
MyFlash copied to clipboard

FAQ中在开启GTID的mysql恢复时加入skip-gtid依然报错

Open zi000 opened this issue 7 years ago • 0 comments

[root@slave2 binary]# ./mysqlbinlog20160408 binlog_output_base.flashback --skip-gtids |mysql -uroot -proot mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1782 (HY000) at line 18: @@SESSION.GTID_NEXT cannot be set to ANONYMOUS when @@GLOBAL.GTID_MODE = ON.

在开启GTID的mysql中按照FAQ的指导加上了skip-gtids恢复,依然报错。

zi000 avatar Feb 07 '18 08:02 zi000