mysqldump: Error 2013: Lost connection to MySQL server during query when dumping
MySQL用Workbench匯出資料庫報錯
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `mc_job` at row: 15308981
改了以下資料庫引數:
wait_timeout:28800
interactive_timeout:28800
max_allowed_packet:1073741824
還是會報錯。
之前以下這個資料庫引數是這樣設定:
net_read_timeout:120
net_write_timeout:900
於是把這個引數修改為:
net_read_timeout:28800
net_write_timeout:28800
重新匯出資料庫成功。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22996654/viewspace-2636746/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mysqldump匯出報錯"mysqldump: Error 2013 ... during query when dumping tableMySqlError
- MySQL報錯ERROR 2013 (HY000): Lost connection to MySQL server during queryMySqlErrorServer
- Mysql mysql lost connection to server during query 問題解決方法MySqlServer
- ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization paErrorMySqlServer
- MySQL:Lost connection to MySQL server at 'readingMySqlServer
- Lost connection to MySQL server at 'reading authorization packet'MySqlServer
- 連線mysql報錯lost connect to sever during query解決MySql
- mysqldump: Error: Binlogging on server not activeMySqlErrorServer
- Dr.Elephant mysql connection errorMySqlError
- 錯誤Error during artifact deployment. See server log for details.ErrorServerAI
- Laravel query when 的查詢Laravel
- mysqldump Got error: 1045MySqlGoError
- mysqldump Got error 1290MySqlGoError
- DZ論壇MySQL Query Error Errno:1046錯誤MySqlError
- mysql匯入sql檔案報錯 ERROR 2013 2006 2002MySqlError
- MySQL異常刨析:ata source rejected establishment of connection, message from server: “Too many connectionMySqlServer
- ERROR 1290 (HY000): The MySQL server is running withErrorMySqlServer
- SQL Server CASE WHEN ... THEN ... ELSE ... ENDSQLServer
- MySQL案例09:Last_IO_Error: Got fatal error 1236 from master when reading data from binary logMySqlASTErrorGo
- ERROR 2026 (HY000): SSL connection error: unknown error numberError
- Error:Can't connect to SOCKS proxy:Connection refused (Connection refused)Error
- MyEclipse - Retrieving archetypes: has encountered a problem An internal error occurred duringEclipseError
- ERROR 1290:The MySQL server is running with the --secure-file-priv optionErrorMySqlServer
- mysql 5.7.21 CMake Error: The source directory "/data/server/mysql" does not appear to contain CMakMySqlErrorServerAPPAI
- Error: Connection activation failed: Device not managed by NetworkManagerErrorAIdev
- Error occurred during initialization of boot layer java.lang.module.FindExceptionErrorbootJavaIndexException
- MySQL主從複製報錯:Got fatal error 1236 from master when reading data fromMySqlGoErrorAST
- MYSQL-mysqldump學習MySql
- Error!: SQLSTATE[HY000] [2002] Connection refusedErrorSQL
- [network][easy case]troubleshoting the connection to a remote serverREMServer
- ORA-55507: Encountered mining error during Flashback Transaction Backout. functiError
- mysql中case when的使用MySql
- mac scrcpy 報錯 does not exist or is not a regular file,ERROR: Server connection failed(scrcpy mac與極空間衝突)MacErrorServerAI
- MySQL:MTS和mysqldump死鎖MySql
- ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables optErrorMySqlServer
- oracle OGG-01232 Receive TCP params error:TCP/IP error 232(connection reset)OracleTCPError
- mysqldump error1066 錯誤的解決辦法MySqlError
- Microsoft SQL Server, Error: 15128 ()ROSSQLServerError