Not sure about the size of your dump, but, have you tried to set the new
value on the server and client side? you can increase max_allowed_packet up
to 1G. Let us know after you tried that, and maybe other guys have another
solution to share...
--
*Wagner Bianchi, +55.31.8654.9510*
Oracle ACE
Hi,
When we are trying to restore the dump file, we got an error like Got a
packet bigger than max_allowed_packet. Then we increased max_allowed_packet
variable size and passed along with MySQL restore command.
mysql -max_allowed_packet=128M -uusername -p /path/file.sql
After increasing the