The workaround for error 1840 when MySQL imports the database

1. Phenomenon

When MySQL imports the database with SQL files, it prompts the error 1840 (HY000) at line: @ @GLOBAL. Gtid_purged can only is set when @ @GLOBAL. Gtid_executed is empty.

Description: The MySQL database was just installed, has never been configured for master-slave replication, and has not been configured for Gtid master-slave replication.

　　

2. Solution

After checking the online information, after the test found that the following method can solve my problem

Go to MySQL mode, reset Master

# mysql-u Root-p

Enter password

mysql> Reset Master;

　　

After exiting, re-import, OK. Let the machine import the data on its own.

　　

The workaround for error 1840 when MySQL imports the database