ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBA
在MySQL 5.7版本中,備份遷移資料庫的時候,還原時提示如下報錯資訊
ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty
當前GTID_EXECUTED引數已經有值
解決方法:
方法一:reset mater
這個操作可以將當前庫的GTID_EXECUTED值置空
方法二:--set-gtid-purged=off
在dump匯出時,新增--set-gtid-purged=off引數,避免將gtid資訊匯出
mysqldump -uroot -p --set-gtid-purged=off -d yoon > yoon.sql
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28939273/viewspace-2375335/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty
- ld: -pie can only be used when targeting iOS 4.2 or later clang: error: linker command failed with eiOSErrorAI
- Only AI Flow Can Do!AI
- 完美解決stack Error: Can‘t find Python executable “python“, you can set the PYTHON env variable.ErrorPython
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- ERROR 2026 (HY000): SSL connection error: unknown error numberError
- ERROR 1114 (HY000) The table '' is fullError
- Error!: SQLSTATE[HY000] [2002] Connection refusedErrorSQL
- ERROR 1290 (HY000): The MySQL server is running withErrorMySqlServer
- TypeError: only integer scalar arrays can be converted to a scalar indexErrorIndex
- linux下連線mysql報錯ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysqLinuxMySqlErrorServer
- Can't open file: (errno: 24)
- ERROR 1290 (HY000) 解決辦法Error
- Binary XML file line #2: Error inflatingXMLError
- Error running ‘Application’Command line is too longErrorAPP
- mac提交svn提示CHECKOUT can only be performed on a version resourceMacORM
- Solaris awk: syntax error near line 1 awk: bailing out near line 1ErrorAI
- 解決ERROR 1030 (HY000): Got error 168 from storage engine apparmorErrorGoAPP
- mysql遇到Variable can’t be set to the value of ‘NULL’MySqlNull
- [20181011]12c set FEEDBACK only.txt
- Mysql連線錯誤ERROR 2003 (HY000)MySqlError
- 關於Warning: setState(...): Can only update a mounted or mounting component. This
- "Only fullscreen opaque activities can request orientation "問題再分析Opaque
- "ScrollView can host only one direct child"問題解決View
- 消除Warning: Using a password on the command line interface can be insecure的提示
- 【C進階】#error和#line使用分析Error
- TypeError: Tensor objects are only iterable when eager execution is enabled. To iterate over this tErrorObject
- 【MySQL】ERROR 1878 (HY000): Temporary file write failure.MySqlErrorAI
- Android8.0適配-Only fullscreen opaque activities can request orientationAndroidOpaque
- ORA-12801 AND ORA-01031 ONLY WHEN OGG DDL TRIGGER IS ENABLED [ID 1280235.1]
- Unknown initial character set index ‘255‘ received from server. Initial client character set can beIndexServerclient
- [20181105]再論12c set feedback only.txt
- Mysql:Variable 'XXXt' can't be set to the value of 'NULL'解決MySqlNull
- ERROR 1786 (HY000): Statement violates GTID consistency: CREATE TABLE ... SELECTError
- ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization paErrorMySqlServer
- Can GoldenGate Replicate An Oracle Table That Contains Only CLOB Column(s)? (Doc ID 971833.1)GoOracleAI
- GCC編譯遇到“a label can only be part of a statement and a declaration is not a statement”問題GC編譯
- mysqldump: Error 2013: Lost connection to MySQL server during query when dumpingMySqlErrorServer