Mysqldump Error 2013
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 error 2013: lost connection to mysql server company Business Learn more about hiring developers or posting ads with us Database Administrators Questions mysqldump: got error: 2013: lost connection to mysql server during query when using lock tables Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish mysqldump net_write_timeout to 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
Mysqldump Connection Timeout
voted 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 net_read_timeout mysql out 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
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Database Administration & Monitoring :: MySqlDump Error 2013, what is it? New Topic Advanced Search MySqlDump Error 2013, what is it? Posted by: jeff mysqldump skip table perreault () Date: December 15, 2008 12:12PM I am backing up a database using
Mysql Lost Connection
MySQLDump and am having troubles. The database is a wikidatabase, not huge and is a mixture of InnoDB and MyIsam
Mysqldump Quick
tables. The table in 'text' is 40,000 records and is InnoDB. $ mysqldump -q -e wikidatabase >> backup.sql $ mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `text` http://dba.stackexchange.com/questions/97846/mysqldump-error-2013 at row: 4584 I have tried using the --quick option and I get the same error. I have tried exporting other tables, and they work. When I try to export the 'text' table on it's own, I get the same error. $ mysqldump -q -e wikidatabase text >> backup.sql $ mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `text` at row: 4584 What http://forums.mysql.com/read.php?35,238661,238661 does this error mean? Do I have a corrupt table? A corrupt row? I'm thinking about deleting the row in question (of course I can't create a backup) Edited 1 time(s). Last edit at 12/15/2008 12:46PM by jeff perreault. Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted MySqlDump Error 2013, what is it? jeff perreault 12/15/2008 12:12PM Re: MySqlDump Error 2013, what is it? John Daisley 12/16/2008 10:12AM Re: MySqlDump Error 2013, what is it? jeff perreault 12/16/2008 11:38AM Re: MySqlDump Error 2013, what is it? Umesh Shastry 12/22/2008 05:46AM Sorry, you can't reply to this topic. It has been closed. powered by phorum Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party. Contact Sales USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany: +49 89 143 01280 France: +33 1 57 60 83 57 Italy: +39 02 249 59 120 UK: +44 207 553 8447 Japan: 0120-065556 China: 10800-811-0823 India: 0008001005870 More Countries» Contact Us Online» Products MySQL Enterprise Edition MySQL Standard Edition MySQL Classic Edition MySQL Cluster CGE MySQL Embedded (OEM/ISV) Services Training Certification Consulting Support Downloads
Sep 2009 12:08 Reporter: John Miller Email Updates: Status: Verified Impact on me: None Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request) Version:5.1.34-community via TCP/IP OS:Microsoft https://bugs.mysql.com/bug.php?id=46103 Windows (2k3 SP2) Assigned to: Triage: Needs Triage: D2 (Serious) View Add https://forums.zarafa.com/showthread.php?7823-mysqldump-error-when-backing-up-properties-table Comment Files Developer Edit Submission View Progress Log 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 1>test.backup mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `mantis_bug_file_table` lost connection 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 | +-----+-----------------+--------+-------------+ 1 row in set (0.00 sec) If I go into my application (mantis) and remove that attachment - removing that row from 2013: lost connection 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
Integration mysqldump error when backing up properties table? Zarafa is hiring!We are looking for new team members at Zarafa! Are you (or do you know) a C++ expert, a JavaScript specialist or a testing guru? Check out our careers page to learn more and apply. Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 11 Thread: mysqldump error when backing up properties table? Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 29-07-2012,07:07 AM #1 tronic View Profile View Forum Posts Private Message Junior Member Join Date Mar 2012 Posts 23 mysqldump error when backing up properties table? hi, when backing up the properties table using mysqldump, i get the following error since a few days now: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `properties` at row: 1620312 any advice ow to fix this? is this a common problem? i use zarafa 7.0.6! thanks Reply With Quote 17-08-2012,11:28 AM #2 devnull View Profile View Forum Posts Private Message Junior Member Join Date Feb 2012 Posts 12 Hi; I have the identical same problem, but different row number, all attempts to select that row or do a sql dump will crash the engine. Code: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `properties` at row: 3739316 Can someone offer some help please ?? Last edited by devnull; 17-08-2012 at 11:44 AM. Reply With Quote 17-08-2012,01:38 PM #3 fbartels View Profile View Forum Posts Private Message Visit Homepage Zarafa Join Date Jan 2009 Location Hanover, Germany Posts 1,696 Can you give your exact command for mysqldump? Which parameters are you using? Regards Felix Zarafa ALPHA/BETA/RC feedback in BETA forum please. Zarafa IRC chat: irc.freenode.com > #zarafa Zarafa documentation: http://documentation.zarafa.com/ No support via PM! Please contact our sales team for an offer if you want my full attention. Reply With Quote 18-08-2012,01:39 AM #4 devnull View Profile View Forum Posts Private Message Junior Member Join Date Feb 2012 Posts 12 C