MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Tim Gustafson Date:August 29 2005 1:56pm
Subject:RE: mysqldump: Error 2013
View as plain text  
No, max_allowed_packet is 100 megabytes, and the maximum data field in the database is
50MB right now, and most are well below 10MB.

Tim Gustafson
MEI Technology Consulting, Inc
tjg@stripped
(516) 379-0001 Office
(516) 908-4185 Fax
http://www.meitech.com/ 



-----Original Message-----
From: Hassan Schroeder [mailto:hassan@stripped]
Sent: Monday, August 29, 2005 9:51 AM
To: mysql@stripped
Subject: Re: mysqldump: Error 2013


Gustafson, Tim wrote:

> When backing up this table, I get this error message every night:
> 
> /usr/local/bin/mysqldump: Error 2013: Lost connection to MySQL server
> during query when dumping table `DocumentVariants` at row: 13456
> 
> The table actually has 94,916 rows in it.  There are no entries in the
> mySQL server log and nothing in /var/log/messages.  There is plenty of
> disk space available on the backup drive.  The file is about 4.5GB when
> this happens, which is about 1/5 of the total table size.  The table
> itself contains a lot of binary data in a longblob field, in case that
> makes any difference.  

Does the size of the contents of that field exceed your defined
max_allowed_packet size?

-- 
Hassan Schroeder ----------------------------- hassan@stripped
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

                           dream.  code.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


Attachment: [application/x-pkcs7-signature] smime.p7s
Thread
mysqldump: Error 2013Tim Gustafson29 Aug
  • Re: mysqldump: Error 2013SGreen29 Aug
  • Re: mysqldump: Error 2013Hassan Schroeder29 Aug
  • Re: mysqldump: Error 2013Gleb Paharenko29 Aug
  • re:mysqldump: Error 2013(christophe charron)7 Sep
    • Re: re:mysqldump: Error 2013Gleb Paharenko7 Sep
RE: mysqldump: Error 2013Tim Gustafson29 Aug
RE: mysqldump: Error 2013Tim Gustafson29 Aug
  • Re: mysqldump: Error 2013Hassan Schroeder29 Aug
Re: mysqldump: Error 2013Michael Stassen29 Aug
RE: mysqldump: Error 2013Tim Gustafson29 Aug
RE: mysqldump: Error 2013Tim Gustafson30 Aug
RE: mysqldump: Error 2013Tim Gustafson2 Sep