执行:

[root@t1 ~]# mysql -uroot -pjsb  ailanni < /root/ailanni.sql
Warning: Using a password on the command line interface can be insecure.
ERROR 1840 (HY000) at line 24: GTID_PURGED can only be set when GTID_EXECUTED is empty.
[root@t1 ~]# mysql -uroot -pjsb  ailanni 


ERROR 1840 (HY000) at line 24: GTID_PURGED can only be set when GTID_EXECUTED is empty.

解决:

reset master


再次执行,OK


参考:

http://www.linuxidc.com/Linux/2013-04/82713p2.htm



Logo

更多推荐