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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQl報錯之@@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ONMySql
- ERROR 23 (HY000) at line 29963: Out of resources when opening fileError996
- ld: -pie can only be used when targeting iOS 4.2 or later clang: error: linker command failed with eiOSErrorAI
- MYSQL ERROR 2003 (HY000) CanMySqlError
- MySQL "ERROR 1010(HY000):Error dropping database(canMySqlErrorDatabase
- ERROR 1135 (HY000): Can't create a new threadErrorthread
- ERROR 1135 (HY000): Can't create a new thread (errno 11)Errorthread
- 【MySQL】ERROR 1005 (HY000): Can't create table' (errno: 150)MySqlError
- oracle安裝遇到:CreateFile() error 32 when trying set file timeOracleError
- MySQL ERROR 1031 (HY000) at line 33: Table storage engine forMySqlError
- ERROR 1005 (HY000): Can't create table 'starive.SC' (errno: 150)"Error
- ERROR 1005 (HY000): Can't create table'matrix.system_log' (errno: 150)Error
- ERROR 2002 (HY000): Can't connect server socket /tmp/mysql.sockErrorServerMySql
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- [MONGODB]: WHEN ARBITER REQUIRED FOR REPLICA SETMongoDBUI
- 完美解決stack Error: Can‘t find Python executable “python“, you can set the PYTHON env variable.ErrorPython
- MySQL 5.7向表匯入資料包錯"ERROR 13 (HY000): Can't get stat of"MySqlError
- MySQL報錯'ERROR 2002 (HY000): Can't connect to local MySQL server through'MySqlErrorServer
- ERROR 2003 (HY000)Can't connect to MySQL server on '192.168.8.247' (113)ErrorMySqlServer
- ERROR 2002(HY000):Can't connect to local MySQL socket '/tmp/mysql.sock'ErrorMySql
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)ErrorMySqlServerlocalhost
- for public synonym, only sys user can compile it?Compile
- ERROR 2002 (HY000): Can't connect server socket /var/run/mysqld/mysqld.sockErrorServerMySql
- mac提交svn提示CHECKOUT can only be performed on a version resourceMacORM
- TypeError: only integer scalar arrays can be converted to a scalar indexErrorIndex
- Android @Field parameters can only be used with form encodingAndroidORMEncoding
- 錯誤處理--pure specifier can only be specified for functionsFunction
- ASM Diskgroup Can Not Be Shown When Creating Database With DBCAASMDatabase
- ERROR 1010 (HY000): Error dropping databaseErrorDatabase
- ONS自動offline - Authentication OSD error, op: scls_auth_client_response_setErrorclient
- expdp report error when export tablesErrorExport
- mysql遇到Variable can’t be set to the value of ‘NULL’MySqlNull
- mysql:Variable 'character_set_client' can't be set to the value of 'NULL'解決MySqlclientNull
- Troubleshooting when srvctl can't start RAC instance, but sqlplus can start it [ID 844272.1]SQL
- ERROR 1524 (HY000): Plugin is not loadedErrorPlugin
- ERROR 2026 (HY000): SSL connection error: unknown error numberError
- "Only fullscreen opaque activities can request orientation "問題再分析Opaque
- NBU report error 6 when RMAN backupError