ERROR 1153: Got a packet bigger than 'max_allowed_packet' bytes

[Miroslav Koula]

Hi,

I need get inside MySQL a mysqldump file which is about 3.8GB large. I am trying:

mysql -u root -p < /data/backup/dump/mysqldump_utf.txt

It starts make some small databases and die saying:

ERROR 1153 (08S01) at line 1752: Got a packet bigger than 'max_allowed_packet' bytes

I try to experiment under the documentation like:

mysql -u root -p -- --max_allowed_packet=32M < /data/backup/dump/mysqldump_utf.txt
mysql -u root -p -- --max_allowed_packet=500M < /data/backup/dump/mysqldump_utf.txt

but always the same... Have you any suggestion what to do?

Thanks everybody

mIREK