ERROR 1153 (08S01) at line 1: Got a packet bigger than 'max_allowed_packet' bytes

 

SOLUTION
mysql> set global net_buffer_length=10000000000;
Query OK, 0 rows affected, 1 warning (0.00 sec)
 
mysql> set global max_allowed_packet=1000000000;
Query OK, 0 rows affected (0.00 sec)
 
 
OR 
in /etc/my.ini
	[mysqld]
max_allowed_packet=300M 

Latest Post

Popular Post

Our Skills

Author

Project Director Information Architect Database Administrator Unix Administrator Senior Developer Project Manager Product Manager Web Marketer Cloud Engineer

Contact Us

For any questions or project ideas please contact me at the following.

I'm here