MySQL导入报错：ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
如题所示，报错发生在MySQL数据导入的时候；
一般发生该错误的原因是导出端的MySQL开启了GTID，因此，导出数据的时候，默认都会启用GTID；
如果不希望遇到该问题，可以在【mysqldump】的时候，加上选项：【 –set-gtid-purged=OFF 】
[……]
- Posted on:
-
Author:
Adamhuan
- Categories: MySQL
- Tags: -, -p, ，, :, /, error, ERROR 1840 (HY000) AT LINE 24: @@GLOBAL.GTID_PURGED CAN ONLY BE SET WHEN @@GLOBAL.GTID_EXECUTED IS EMPTY., GTID, MySQL, mysqld, mysqldump, purge, rap, s, SQL, 启用, 导入, 导出, 报错, 数据, 选项, 错, 错误, 问题, 默认
- Leave a comment: MySQL导入报错：ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.