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
