Ads

Got a packet bigger than ‘max_allowed_packet’ bytes mysql

December 18, 2008
Filed under: Featured, MySQL 5.1, MySql, MySql 5.0, PHP 

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

set this from putty.




set-variable=record_buffer=16M

set this in my.cnf

Tags: ,

Comments

Tell me what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!





*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

Subscribe without commenting