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?