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]
