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
3 years ago 2 Answer 22 views

Answers ( 2 )

  1. 3 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. 3 years ago

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

Your Answer

Related Questions