Re: change value of max_allowed_packet

[Arun Venkatesan]

You could do it in either of the following ways:

1. Change in the my.ini file. Include the single line under [mysqld] in your file

# sets max_packet to 500 MB
max_allowed_packet=500M

now restart the MySQl service and you are done

2. At the command prompt, execute the foll. command
mysql> set global max_allowed_packet = 500 * 1024 * 1024;

This will set the global max packet size to 500 MB. All subsequent MySQL client connections will get this value as their session value for max packet