RSS

Set max allowed packet in mysql

08 Sep

Ever got the error “com.mysql.jdbc.PacketTooBigException: Packet for query is too large (5224044 > 4193280)”

When try to extract the dump in mysql.

Please give the command in sql,

set global max_allowed_packet = 16777216;

 
Leave a comment

Posted by on September 8, 2011 in MySQL

 

Tags: , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: