MyFlash
MyFlash copied to clipboard
FAQ中在开启GTID的mysql恢复时加入skip-gtid依然报错
[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恢复,依然报错。