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
- mysql5.5_2013 Lost connection to Mysql server during queryMySqlServer
- 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
- 連線mysql報錯lost connect to sever during query解決MySql
- 【MySQL】mysqldump Error 3024: Query execution was interruptedMySqlError
- Lost connection to MySQL server at 'reading authorization packet'MySqlServer
- Network Connection Lost When Windows 8 Goes To SleepWindowsGo
- Lost connection to MySQL server at ‘reading initial communication packet', system error: 0 mysql遠端連線問題MySqlServerError
- MongoDB mongoimport 報錯:lost connection to serverMongoDBImportServer
- Mysql連線錯誤:Lost connection to Mysql server at 'waiting for initial communication packet'MySqlServerAI
- mysqldump: Error: Binlogging on server not activeMySqlErrorServer
- Dr.Elephant mysql connection errorMySqlError
- mysqldump: Got error: 2002: Can't connect to local MySQL server through.....MySqlGoErrorServer
- Dr.Elephant mysql connection error薦MySqlError
- 錯誤Error during artifact deployment. See server log for details.ErrorServerAI
- Laravel query when 的查詢Laravel
- mysqldump Got error: 1045MySqlGoError
- What happens when exadata has lost two disks?(轉)APP
- Software caused connection abort: socket write error/mysql/tomcatErrorMySqlTomcat
- DZ論壇MySQL Query Error Errno:1046錯誤MySqlError
- sencha architect/sencha touch , to prevent breakpoint lost when you debug
- mysqldump Got error 1290MySqlGoError
- An error occurred during bosboot verification processingErrorboot
- 【MySQL】Testing mysql connection and privileges..ERROR 1173 (42000)MySqlError
- MySQL mysqldump命令MySql
- Oracle - ORA-28547: Connection to server failed,probable Oracle Net admin error (Navicat)OracleServerAIError
- MSSQLServer 上討厭的錯誤error: 40 - Could not open a connection to SQL ServerSQLServerError
- Error: package MySQL-Cluster-server-gpl is not relocatableErrorPackageMySqlServer
- ORA-12801: error signaled in parallel query server PZ99分析ErrorParallelServer
- expdp report error when export tablesErrorExport
- Connection/Session/Server ProcessesSessionServer
- MySQL異常刨析:ata source rejected establishment of connection, message from server: “Too many connectionMySqlServer
- SQL Server CASE WHEN ... THEN ... ELSE ... ENDSQLServer
- 【MySql】mysqldump 的用法MySql
- mysql case when then 使用MySql