问题:ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
解决:
1、登入数据库执行reset master----无效
2、修改导入的文件:----生效
注释掉这一行:SET @@GLOBAL.GTID_PURGED=
/*SET @@GLOBAL.GTID_PURGED=XXXX*/;
执行步骤1后仍报错,执行步骤2可正常导入:
mysql -u账号-h serverIp-P 3306 -p密码 库名 < *.sql