This site is hosted and sponsored by hyve.com specialists in Cloud Hosting UK and VMware Hosting. If you are interested in our services please call us for chat on 0800 612 2524

When you change Max_Allowed_Packet_Size using the command line or an admin tool, sometimes it doesnt work.#

The best way to do this is to edit the my.cnf file and add under the mysqld section the following line:

Normally it is good to set the value to around 16mb. It is only set to 1mb by default.

[mysqld]
max_allowed_packet=16MB

Restart mySQL after you have edited teh file:

On Linux:

/etc/rc.d/init.d/mysqld restart

On Windows:

Use services to restart

Back to mySQL