GTID 模式在同步数据,恢复备份时遇到以下报错:
ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
解决方法:
重置 master 即可
root@localhost [(none)]>reset master;
GTID 模式在同步数据,恢复备份时遇到以下报错:
ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
解决方法:
重置 master 即可
root@localhost [(none)]>reset master;