Noob question - set max_allowed_packet?

[acoldone]

Is there any way of setting max_allowed_packet? I'm trying to import data using a sql statement and rather than have to chop up some of the insert statements is there a way to set this? I tried using the shell but it doesn't seem to work? Stills shows up as 1 MB max.

[Smithjp]

You can increase max_allowed_packet by specifying size in /etc/my.cnf:

max_allowed_packet = 32M

Make sure that you restart the mysql (service mysql restart) after making changes to my.cnf.

[acoldone]

You can increase max_allowed_packet by specifying size in /etc/my.cnf:

max_allowed_packet = 32M

Make sure that you restart the mysql (service mysql restart) after making changes to my.cnf.

Do you have to create this file yourself? I checked out the vps root directory "etc" and didn't find the file? I tried creating a simple file with:

[mysqld]
max_allowed_packet=16M

I put it in the etc root folder. I also tried naming it with a dot in front? ".my.cnf". Not sure what I'm doing wrong.

[Smithjp]

It should be there. Please open a support ticket and we will check it out and let you know.

[thisisit3]

The file "my.cnf" didn't exist in my systems as well, so i created mine with:

[mysqld]
set-variable = max_connections=1000