Page 1 of 1

[MySQL] Updating config file, changes not taking effect

Posted: Wed Aug 31, 2011 9:19 am
by RCA86
Hi guys,

I'm trying to change the value of 'max_allowed_packet' size, as I've had a problem with a Drupal import. I changed the 'my.cnf' (in /etc/) file and added the following line:

set-variable = max_allowed_packet=64M

Then restarted the service, but when I run a 'show variable' command, the value is stuck at: 1048576. I also tried without the 'set-variable' command, and just: max_allowed_packet=64M, restarted service, but this didn't work.

I'm not sure what I'm missing here, because the config file is definitely changing (have triple-checked), and the server is definitely restarting correctly. All I can think of is that there might be another setting overriding it, or the line I've entered is somehow invalid.

Any ideas? :banghead: