Mysqldump Error 2013 Lost Connection To Mysql Server During Query
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company
Mysqldump: Got Error: 2013: Lost Connection To Mysql Server During Query When Using Lock Tables
Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags mysqldump net_write_timeout Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to
Mysqldump Connection Timeout
improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted net_read_timeout mysql up and rise to the top mysqldump Error 2013 up vote 6 down vote favorite 2 I have a database installed, that I would like to backup in mysql. The problem is mysqldump fails on exporting the 'maia_mail' table # mysqldump -u root -p maia > maia.sql mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `maia_mail` at row: 15 It runs for less than 30 seconds and gets error out mysql lost connection as above. The total size of the DB is 1.3GB with the maia_mail table being 1.0GB In my.cnf I have these set: [mysqld] max_allowed_packet = 1300M [mysqldump] max_allowed_packet = 1300M Please advise or give some guidance on how to dump the database? mysql mysqldump share|improve this question edited Apr 15 '15 at 1:08 KASQLDBA 4,38011436 asked Apr 14 '15 at 19:17 garfink 3113 Do you have enough space on the hard drive? Try watching the space while the dump is being done. –Jehad Keriaki Apr 14 '15 at 19:41 @jehad Keriaki - 170GB free space. It's also the same whether I dump to machine db is on or remote –garfink Apr 14 '15 at 19:49 What type of data this table has.. do you think it has special characters that affects saving into text file? –Jehad Keriaki Apr 14 '15 at 19:55 copies of email so varchar data mainly –garfink Apr 14 '15 at 20:01 Restore max_allowed_packet to its default value max_allowed_packet=1048576 (Restart the server after that plz) –Jehad Keriaki Apr 14 '15 at 20:14 | show 7 more comments 3 Answers 3 active oldest votes up vote 4 down vote I could easily suggest changing InnoDB settings which might be a littel heavy-handed just to get a mysqldump to work. You ma
Sep 2009 12:08 Reporter: John Miller Email Updates: Status: Verified Impact on me: None Category:MySQL Server: mysqldump Command-line Client
Mysqldump Skip Table
Severity:S4 (Feature request) Version:5.1.34-community via TCP/IP OS:Microsoft Windows (2k3 SP2) mysqldump quick Assigned to: Triage: Needs Triage: D2 (Serious) View Add Comment Files Developer Edit Submission View Progress Log
Error 2013 (hy000): Lost Connection To Mysql Server During Query
Contributions [9 Jul 2009 22:47] John Miller Description: This command gets run as part of our backup: D:\util\mantis_backup_test>mysqldump -q -e --max_allowed_packet=500m --net_buffer_length=16m -u XXXX -pXXXXXXXXX rpcbugtracker http://dba.stackexchange.com/questions/97846/mysqldump-error-2013 1>test.backup mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `mantis_bug_file_table` at row: 743 Row 743 does not seem "special": mysql> select id, length(content), bug_id,filename from mantis_bug_file_table where id=743; +-----+-----------------+--------+-------------+ | id | length(content) | bug_id | filename | +-----+-----------------+--------+-------------+ | 743 | 76288 | 2313 | P0130rs.doc | +-----+-----------------+--------+-------------+ https://bugs.mysql.com/bug.php?id=46103 1 row in set (0.00 sec) If I go into my application (mantis) and remove that attachment - removing that row from the table: mysql> select id, length(content), bug_id,filename from mantis_bug_file_table where id=743; Empty set (0.00 sec) I just get the same error with a different row: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `mantis_bug_file_table` at row: 429 The table itself is big: D:\Program Files\MySQL\MySQL Server 5.0\data\rpcbugtracker>dir /os Volume in drive D is Applications Volume Serial Number is 1099-7FDC Directory of D:\Program Files\MySQL\MySQL Server 5.0\data\rpcbugtracker 01/21/2009 05:03 AM
2014 20:41 Reporter: - - Email Updates: Status: No Feedback Impact on me: None Category:MySQL Server: InnoDB storage https://bugs.mysql.com/bug.php?id=72519 engine Severity:S3 (Non-critical) Version:5.5.37 OS:Linux (Ubuntu 14.04) Assigned to: View Add Comment Files Developer Edit Submission View Progress Log Contributions [3 May 2014 3:09] - - Description: I tried to backup my database with the mysqldump command. But it failed with an error message, "mysqldump: Error 2013: Lost connection to MySQL server during query when lost connection dumping table `creation_log` at row: 59655". The log of mysqldump was: ======================================== nodchip@nighthawk ~ % mysqldump -uroot -p[password] -A -v --flush-privileges --rou tines --result-file mysql_backup_2014-05-03.sql (skipped) -- Retrieving table structure for table creation_log... -- Sending SELECT query... -- Retrieving rows... mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `creation_log` lost connection to at row: 59655 ======================================== I added "innodb_force_recovery = 6" to [mysqld] section in my.cnf, restart the mysqld and tried mysqldump again. But the result was not changed. The definition of "creation_log" table is: ======================================== mysql> desc creation_log; +------------+------------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+-------------------+-----------------------------+ | PROBLEM_ID | int(10) unsigned | NO | MUL | NULL | | | USER_CODE | int(10) unsigned | NO | | NULL | | | DATE | timestamp | NO | MUL | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | | MACHINE_IP | text | NO | MUL | NULL | | | SUMMARY | text | YES | | NULL | | +------------+------------------+------+-----+-------------------+-----------------------------+ ======================================== I tried "ALTER TABLE