Page 1 of 1

Error: MySQL server has gone away

Posted: Sat Jun 12, 2010 8:23 pm
by jr
If you get an error that looks similar to the one below it could be related to the transfer of large binary fields.

Error moving data
Error: -2147467259
Reason: [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]MySQL server has gone away

A possible workaround could be to increase the value of max_allowed_packet (http://dev.mysql.com/doc/refman/5.0/en/ ... wed_packet).

In a test I increased the value from the default 1 MB to 50 MB and got rid of the problem.

Regards,
Jacob