TJ111
07-02-2007, 04:36 PM
I'm setting up a file upload to a mysql database, however the default max_allowed_packet is 1mb. I've been doing this for like an hour and still have had no luck getting the max_allowed_packet change to be permanent. Here's what I've done.
1. Added "MAX_ALLOWED_PACKET=16MB;" to my.conf.
2. Set it through shell commands
i.Connect to Mysql through shell
ii.See current max_allowed_packet("show variablies like 'max_a%';")
iii.It returns ("max_allowed_packet | 1048576").
iv.Set the max allowed packet ("set max_allowed_packet=16777216;")
v."show variablies like 'max_a%';"
vi.It returns ("max_allowed_packet | 16777216;")
vii.Exit ("exit;")
viii. Restart mysql server ("/etc/rc.d/init.d/mysqld restart")
ix. Connect to mysql server
x. "Show variables like 'max_a%';"
xi. It returns ("max_allowed_packet | 1048576").
It's driving me nuts! How do you make the max_allowed_packet size permanent??
1. Added "MAX_ALLOWED_PACKET=16MB;" to my.conf.
2. Set it through shell commands
i.Connect to Mysql through shell
ii.See current max_allowed_packet("show variablies like 'max_a%';")
iii.It returns ("max_allowed_packet | 1048576").
iv.Set the max allowed packet ("set max_allowed_packet=16777216;")
v."show variablies like 'max_a%';"
vi.It returns ("max_allowed_packet | 16777216;")
vii.Exit ("exit;")
viii. Restart mysql server ("/etc/rc.d/init.d/mysqld restart")
ix. Connect to mysql server
x. "Show variables like 'max_a%';"
xi. It returns ("max_allowed_packet | 1048576").
It's driving me nuts! How do you make the max_allowed_packet size permanent??