RSS feed

Got a packet bigger than 'max_allowed_packet' bytes

December 14th, 2008 | Posted in MySQL | 2 Comments

ERROR 1153 (08S01) at line 3995: Got a packet bigger than ‘max_allowed_packet’ bytes

If you get above error while importing a large MySQL dump connect to MySQL on one terminal and set:

set global max_allowed_packet=1000000000;
set global net_buffer_length=1000000;

Open another terminal and import your dump:

mysql -p < large_db_dump


2 Comments to “Got a packet bigger than 'max_allowed_packet' bytes”

  1. [...] If the database is BIG, you will get errors, please refer to this post to get a [...]

  2. Sajal says:

    Thx buddy!! your the man!


Leave a Comment






Categories