Error: MySQL server has gone away

General usage of Access to MySQL

Moderator: jr

jr
Site Admin
Posts: 500
Joined: Sun Mar 26, 2006 12:28 pm

Error: MySQL server has gone away

Post 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