MYSQL max_allowed_packet won't change, can't restore..

[Daniel Takacs]

Hi all,
Could someone please give some insight on the following please?

Screnario: would like to restore a medium database (846MB), what has a lot of BLOB attachments.

During restore, i get the error message that one of this attachments are larger then max_allowed_packet.
The attachment is 10124159 bytes~10Mb.

(i use

mysql -u root -p -v --max_allowed_packet=1024M -h mydbserver db1 < db1_bak.sql
 

locally in terminal)

My my.cnf is set up with
max_allowed_packet=16M

i tried a couple of things like putting
--max_allowed_packet=1024M into the restore command, set it by set global in mysql prompt, but nothing seems to help.

Restarted the server several times..

One thing i noticed, that after setting the global in mysql prompt the show variables still shows the 16M size.. but it's accepting the set... I don't get it.. i'm in with DBA root, useing the local root user & even sudo...

Can someone help me please?
I'm on MySQL 5.1.37 on a virtualized XUbuntu 9.10 (2 cores AMD 2GB dedicated RAM for the VM, full 16GB on the VM Host)

Thank you, regards.
Daniel

[mwasif]

Is max_allowed_packet=16M written under [mysqld] in my.cnf?

Run the following command on mysql prompt and post the out put here

SHOW VARIABLES LIKE 'max_allowed_packet';