Re: Changing max_allowed_packet on a shared server

[Bill Karwin]

Either of these should do it:

SET GLOBAL max_allowed_packet=1234567

But you'll have to do this every time the MySQL server restarts.

SET SESSION max_allowed_packet=1234567

But this'll be only for the current application's connection, and you'll have to do it every time you connect.

Also, if this is a shared server, you might want to check with the other users first. ;-)

Here's a couple of doc pages that you can read for more info:
http://dev.mysql.com/doc/refman/5.0/en/using-system-variables.html
http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html

Regards,
Bill K.