[ERR] 1840 – @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
当前GTID_EXECUTED参数已经有值
show global variables like '%GTID%';
解决办法:
在dump导出时,添加--set-gtid-purged=off参数,避免将gtid信息导出:
mysqldump db_name -uroot -p --set-gtid-purged=off > /var/sql_name.sql
还有一种方法:
reset master;