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 1286 (42000): Unknown storage engine 'MyISAM'MySqlError
- MySQL建立觸發器時報錯Error Code: 1064MySql觸發器Error
- mysql的ERROR 1231 (42000)問題原因及解決方法MySqlError
- ERROR 1410 (42000): You are not allowed to create a user with GRANTError
- 解決ERROR 1231 (42000): Variable 'time_zone' can'tError
- mysql安裝教程8.0.26 安裝mysql的步驟和方法MySql
- 偶遇ERROR 1071 (42000): Specified key was too long; max key length is 767 bytesError
- ogg oracle 同步mysql的一個莫名其妙的語法錯誤排查GG-00768 SQL error (1064)OracleMySqlError
- [Error Code: 904, SQL State: 42000] ORA-00904 : 識別符號無效ErrorSQL符號
- Laravel5.4 資料庫遷移錯誤 SQLSTATE [42000] Syntax error or access violation 1071Laravel資料庫SQLError
- [報錯:字元太長] SQLSTATE [42000]: Syntax error or access violation: 1071 Specified key was t oo long;字元SQLError
- MySQL 鎖bug?MySql
- 莫名其妙的BUG——Compilation errorError
- @Deprecated 的作用
- mysql Unknown error 1054MySqlError
- docker image rm發生錯誤 Error response from daemon: conflict: unable to remove repository referenceDockerErrorREM
- MySQL error 錯 誤 碼MySqlError
- MySQL：關於Bug #81119MySql
- MYSQL connector 的 NullReferenceException bugMySqlNullException
- MySQL:關於Bug #20939184MySql
- PAT-B 1064 朋友數
- ACwing1064. 小國王
- Android Studio ERROR: Installed Build Tools revision 34.0.0 is corrupted. Remove and install again using the SDK Manager.AndroidErrorUIREMAI
- JavaScript remove()JavaScriptREM
- MySQL error log和bin logMySqlError
- Dr.Elephant mysql connection errorMySqlError
- MySQL ERROR 1040: Too many connectionsMySqlError
- node 報錯 deprecated undefinedUndefined
- MySQL 8.0.26版本升級32版本查詢資料為空的跟蹤MySql
- MySQL UDF 在 in ( subquery where ) bugMySql
- [轉帖]mysqldump --master-data=2 --single-transactionMySqlAST
- mysql-SQL Error: 1205, SQLState: 41000MySqlError
- MySQL主從同步報error 1236MySql主從同步Error
- JavaScript select remove()JavaScriptREM
- DataTransferItemList.remove()REM
- Remove Element 解答REM
- mysql 原生 線上DDL 的bug .MySql
- cf1064D. Labyrinth(01BFS)