peterlaursen wrote on May 11 2007, 03:20 PM:
“Error Code: 2006 – MySQL server has gone away”
I think the most likely reason is that the (server) max_allowed_packet setting is too low compared to the size of BULK inserts in the file.
Old server versions dispaly only that in this situation. 5.0.41 say “got a package too big” or something like that!
Thanks that was exactly the problem. Followed the instructions below
http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
In Linux:
Copy the my-xxx.cnf file from /usr/share/mysql to /etc as my.cnf
xxx can be small, medium, large, huge … depending on the requirement.
$ cp /usr/share/mysql/my-xxx.cnf /etc/my.cnf
In the my.cnf file, change the default
max_allowed_packet = 1M
to
max_allowed_packet = 16M
Save the file and restart MySQL server.
In Windows:
In the MySQL server installation directory,
in my.ini file, add the following line under [mysqld] in SERVER SECTION.
max_allowed_packet = 16M
Save the file and restart MySQL server.
