Error: MySQL server has gone away
Posted: Sat Jun 12, 2010 8:23 pm
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
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