Error: MySQL server has gone away

General usage of Access to MySQL

Moderator: jr

Error: MySQL server has gone away

Postby jr » 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
jr
Site Admin
 
Posts: 491
Joined: Sun Mar 26, 2006 12:28 pm

Return to General

Who is online

Users browsing this forum: No registered users and 2 guests

cron