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 [EMAIL PROTECTED] (516) 379-0001 Office (516) 908-4185 Fax http://www.meitech.com/ -----Original Message----- From: Hassan Schroeder [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 9:51 AM To: mysql@lists.mysql.com 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 ----------------------------- [EMAIL PROTECTED] 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/[EMAIL PROTECTED]
smime.p7s
Description: S/MIME cryptographic signature