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:
- MySQL character set error resolution: err=Error 3988: Conversion from collation utf8mb4_unicode_ci into utf8_general_ci impo
- [Solved] sqoop Import Datas to mysql error: ERROR tool.ExportTool: Error during export: Export job failed
- MySQL server has gone away Error [How to Solve]
- [Solved] mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this opera
- [Solved] mysqldump: Got error: 1556: “You can‘t use locks with log tables.“ when using LOCK TABLES
- [Solved] EOS7.6 Error: Init DB failed [Specified key was too long; max key length is 767 bytes…
- Linux Error: [ERROR] –initialize specified but the data directory has files in it. Aborting.
- MYSQL 5.7 Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it..
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- Zabbix import MySQL database error ERROR 1046 (3D000) at line 1: No database selected
- [Solved] Python import Error: pip –upgrade Error: ERROR: Cannot uninstall ‘dnspython‘. It is a distutils installed
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- 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 gruop by Error: this is incompatible with sql_mode=only_full_group_by
- How to Fix MySQL error 1005: can’t create table (errno: 150)
- [Solved]Error 1054 (42s22): unknown column ‘password’ in ‘field list’ how to modify the password
- [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file ./ibdata
- scm_prepare_database.sh CDH initial data script execute error
- [Solved] ORA-04063: package body “SYS.DBMS_DATAPUMP“ has errors