MySQL Error: Got a packet bigger than ‘max_allowed_packet’ bytes

When trying to import large SQL dump, you often get the above message. Remedy for this issue is to increase the packet size of MySQL’s daemon by setting a packet size of max_allowed_packet. Sudo to your account and set the following

root $ mysql -u admin -p

mysql> set global net_buffer_length=1000000;

mysql> set global max_allowed_packet=1000000000;

In the command line, issue the command

$ mysql –max_allowed_packet=128M -uUSER -pPASSWORD database < database.sql.dump

Share it onShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Written by kurinchilamp


Website: http://

Leave a Reply

Your email address will not be published. Required fields are marked *

Kurinchi Calendar
August 2014
M T W T F S S
« Jul   Feb »
 123
45678910
11121314151617
18192021222324
25262728293031
Read previous post:
Wireframesketcher – Tool for prototyping

Wireframing is one of the most valuable phase of any application development process. Understanding requirements from customers is the key...

Close