Import error content error 1840 (HY000) at line 24: @ @ global GTID_ PURGED can only be set when @@GLOBA
Solution:
when exporting dump, add * * – set gtid purged = off
parameter to avoid using gtid information
When importing,
if – default character set = UTF-8 reports an error, try – default character set = utf8 * *
Read More:
- Zabbix import MySQL database error ERROR 1046 (3D000) at line 1: No database selected
- Dbeaver connects hive to solve the problem that hive custom UDF functions cannot be used in SQL queries in dbeaver
- Dbeaver Import SQL File Error: Error executing process Process failed (exit code = 1). See error log. Process failed (exit code = 1). See error log.
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- MySQL Error: errorCode 1130, state HY000 [How to Solve]
- Error 1418 (HY000): this function has none of deterministic, no SQL
- Mysql8.02/ubuntu 20 ERROR 1449 (HY000) [How to Solve]
- Ubuntu ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
- MySQL 8.0 error 1114 (HY000): the table’sbtest1’is full (Fixed)
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- linux mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- [Solved] ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost‘
- RECEIVED ERROR PACKET: ERRNO = 1236, SQLSTATE = HY000 ERRMSG = COULD NOT FIND FIRST LOG FILE NAME IN BINARY LOG INDEX FILE
- mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin
- ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number
- Doris reports an error: error 1064 (HY000) [How to Solve]
- [Solved] mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this opera
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- [Solved] ERROR 1030 (HY000): Got error 28 from storage engine