[Resolved] ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes [Решено]

I didn't have any luck with --max_allowed_packet; it seems like it didn't do anything.
I just opened two terminals, connected to mysql on one, set the following:
mysql> set global max_allowed_packet=1000000000;
mysql> set global net_buffer_length=1000000;
and then ran:
mysql -p db_name < sqldump.sql
from the other terminal.
Return back parameters:
mysql> set global max_allowed_packet=1048576;
mysql> set global net_buffer_length=16384;

All done.
source