@@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty
備份還原MySQL資料庫報錯:
ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
解決辦法:
匯出正常。
開啟匯出的SQL指令碼。
把下面這行註釋或者刪除:
SET @@GLOBAL.GTID_PURGED=/*!80000 '+'*/ '64d4835c-ab59-11ec-b2c8-fa163e3ee903
徹底點可以刪除。
然後再匯入這個SQL指令碼還原資料庫正常。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22996654/viewspace-2898037/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAError
- 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
- TypeError: only integer scalar arrays can be converted to a scalar indexErrorIndex
- mac提交svn提示CHECKOUT can only be performed on a version resourceMacORM
- mysql遇到Variable can’t be set to the value of ‘NULL’MySqlNull
- [20181011]12c set FEEDBACK only.txt
- 關於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
- TypeError: Tensor objects are only iterable when eager execution is enabled. To iterate over this tErrorObject
- 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
- Mysql:Variable 'XXXt' can't be set to the value of 'NULL'解決MySqlNull
- [20181105]再論12c set feedback only.txt
- GCC編譯遇到“a label can only be part of a statement and a declaration is not a statement”問題GC編譯
- Can GoldenGate Replicate An Oracle Table That Contains Only CLOB Column(s)? (Doc ID 971833.1)GoOracleAI
- 完美解決stack Error: Can‘t find Python executable “python“, you can set the PYTHON env variable.ErrorPython
- 【React】Invalid hook call. Hooks can only be called inside of the body of a function component.ReactHookIDEFunction
- 7.82 EMPTY_BLOB, EMPTY_CLOB
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- 解決問題:Variable 'time_zone' can't be set to the value of 'NULL'Null
- 使用monaco編輯器 報錯Can only have one anonymous define call per script file
- [ERR] 1231 - Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'SQL
- CSS E:emptyCSS
- AndroidStudio之自定義輸出包名報錯 Cannot set the value of read-only property 'outputFile' forAndroid
- 子執行緒呼叫invalidate()產生“Only the original thread that created a view hierarchy can touch its views.”原因分析執行緒threadView
- C++ Empty Class OptimizationC++
- PathVariable annotation was empty on param 0
- static inner class和非static inner class的例項化問題(can only instantiate non-static inner class...)
- Jackson中DeserializationFeature.ACCEPT_EMPTY_STRING_AS_NULL_OBJECT和ACCEPT_EMPTY_STRING_AS_NULL_OBJECTNullObject
- [Typescript] Handling a Truly Empty Object in TypeScriptTypeScriptObject
- jQuery之empty()與remove()方法jQueryREM
- case when 語句
- jQuery操作dom節點empty()方法jQuery
- VirtualBox Host-only Adapter,Failed to create the host-only adapter 轉APTAI
- CAN_NM