返回 登录
0

ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED

导入mysql数据报错:
[root@hch_test_dbm1_121_62 load_binlog]# mysql3309 mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
[root@hch_test_dbm1_121_62 load_binlog]#

【解决方案】
mysql导入之前,先执行 reset master命令
mysql> reset master;
Query OK, 0 rows affected (0.01 sec)

mysql> exit
Bye
[root@hch_test_dbm1_121_62 load_binlog]# mysql3309 mysql: [Warning] Using a password on the command line interface can be insecure.
[root@hch_test_dbm1_121_62 load_binlog]#

评论