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.
