MySQL 8.0.26 bug ERROR 1064(42000) -master-data is deprecated and will be remove
ERROR 1064(42000) at line 1: you have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WARNING: --master-data is deprecated and will be removed in a future version. Us' at line 1
匯出命令
mysqldump -uroot -pmysql --single-transaction -A -R -E --triggers --master-data=2 --flush-logs > full.sql
這個匯出命令沒什麼問題,匯入命令也沒什麼問題啊!!!
more full.sql
有這段資訊,但是沒有註釋掉!!!下面將滴一行註釋掉,再次執行ok了
8.0.25版本測試,沒問題
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29990276/viewspace-2839592/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL建立觸發器時報錯Error Code: 1064MySql觸發器Error
- MySQL procedure SET autocommit=0; Error Code: 1064DELIMITER $$MySqlMITError
- 【MySQL】Testing mysql connection and privileges..ERROR 1173 (42000)MySqlError
- MySQL:ERROR 1286 (42000): Unknown storage engine 'MyISAM'MySqlError
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'ErrorlocalhostDatabaseMySql
- replication 1064 error on slave sideErrorIDE
- 解決Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future:MySqlREM
- MySQL 5.5 報錯"ERROR 1075 (42000): Incorrect table definition"MySqlError
- error code 0x534. [SQLSTATE 42000] (Error 15404)).ErrorSQL
- mysql的ERROR 1231 (42000)問題原因及解決方法MySqlError
- Mac 下的MySQL ERROR 1227(42000): Access denied; you need (at least one of)MacMySqlErrorAST
- mysql安裝教程8.0.26 安裝mysql的步驟和方法MySql
- ERROR 1044 (42000): Access denied for user 'root'@'%' to databaseErrorDatabase
- ERROR 1410 (42000): You are not allowed to create a user with GRANTError
- MySQL_ERROR 1231 (42000) at line XX in file 'file_name' Variable 'time_zone' can't beMySqlError
- DEPRECATED: Use of this script to execute hdfs command is deprecated.
- Error: Debug Failure at typeToStringErrorAI
- 【MySQL】5.6/5.7並行複製bug導致的故障 ERROR 1755/1756MySql並行Error
- PHP Deprecated: Assigning the return value of new by reference is deprecatedPHP
- mysql異常 Install/Remove of the Service Denied!MySqlREM
- 【MySQL】老版本mysql奇怪的報錯:ERROR 1046 (3D000): No database selected(BUG)MySqlError3DDatabase
- 【故障處理】Bug : ASM FAILS WITH CHECKRESOURCE ERROR ERROR CODE = 139ASMAIError
- 解決ERROR 1231 (42000): Variable 'time_zone' can'tError
- The type MultipartEntity is deprecated
- :-1: error: [Makefile.Debug:1234: debug/moc_serialportthread.cpp] Error 1Errorthread
- 解決Deprecated:mysql_connect():Themysqlextensionisdeprecatedandwillberemovedinthefuture:usemysqliorPDOinsteadinMySqlREM
- 用mysqldump --master-data 建立slaveMySqlAST
- MySQL 鎖bug?MySql
- mysql bug 55981MySql
- mysql 安全bugMySql
- error MSB8031 Building an MFC project for a non-Unicode character set is deprecatedErrorUIProjectUnicode
- 偶遇ERROR 1071 (42000): Specified key was too long; max key length is 767 bytesError
- [Error Code: 904, SQL State: 42000] ORA-00904 : 識別符號無效ErrorSQL符號
- ogg oracle 同步mysql的一個莫名其妙的語法錯誤排查GG-00768 SQL error (1064)OracleMySqlError
- MySQL 8.0.26版本升級32版本查詢資料為空的跟蹤MySql
- MySQL儲存函式錯誤[Err] 1064的除錯記錄MySql儲存函式除錯
- remove()REM
- RemoveREM