MySQL Updating max_allowed_packet
This is just short post on settings the max_allowed_packet in MySQL without rebooting it. I always forget how to do it when I need to change it quickly for whatever reason.
set global max_allowed_packet = 32 * 1024 * 1024;This will set it for 32 MEGS. Change the 32 to have it larger or smaller.
Since this resets when the service restarts below is a link to the command line and my.cnf configuration information.