How to resolve MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes

  Jul 29, 2015

I am getting following error, while trying to import a sql scrip of size around 700 M

Please suggest what should i do ?

Solved 0
4 years ago 2 Answer 22 views

Answers ( 2 )

  1. 4 years ago

    Simply file following two commands in your my-sql quesry editor to maximise packet size:

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

  2. 4 years ago

    This can be resolved by increasing the max_allowed_packet value under my.ini file

*Avoid using any other website url of links , otherwise your answer may not be visible on website until verification is complete.

Your Answer

Related Questions