Mysql Server Has Gone Away

[peterlaursen]

In your MySQL server configuration file enter in the [mysqld] section

Code:

max_allowed_packet = 16 M

.. for example and restart MySQL

links:

1) http://www.webyog.com/blog/2009/12/05/sqlyog-mysql-gui-8-2-introduces-data-type-optmizer-and-licensing-changes/

“A calculation error could cause export tools to create BULK INSERT statements larger than specified by user.”

2) http://www.webyog.com/blog/2009/08/10/mysql-server-has-gone-away-part-1-max_allowed_packet/

“The situation is that if a client sends a SQL-statement longer than the server max_allowed_packet setting, the server will simply disconnect the client. Next query from the same client instance will find that the ‘MySQL server has gone away’.”

[Sami]

Ohh…. I must use this theory: “If it isn't there, add there!”

Thanks the support, it is done 🙂

[Author]

Posts