ERROR 1153: Got a packet bigger than 'max_allowed_packet' bytes
Posted by: Miroslav Koula
Date: March 14, 2006 07:18AM


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


Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.