以下转自:http://www.usafreehost.com/?p=160 经本人测试确实有效!
在做两个数据库数据拷贝的时候,遭遇 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes With statement: 遇到这个问题,一般是客户端的 ‘max_allowed_packet’设置不够大。解决方法为:在终端执行以下命令 set global net_buffer_length=1000000; set global max_allowed_packet=1000000000;
但如果你是将数据库copy到虚拟空间上,可能运行这个命令的权限就不够了,变相处理办法,使用单向同步操作来实现copy功能。
Tag:Got a packet bigger than max_allowed_packet bytes,#1153 - Got a packet bigger than max_allowed_packet bytes,1153 - Got a packet bigger than max_allowed_packet bytes,mysql Got a packet bigger than max_allowed_packet bytes,Got a packet bigger than max_allowed_packet bytes With statement,Communication link failure: 1153 Got a packet bigger than max_allowed_packet bytes,1153 Got a packet bigger than max_allowed_packet bytes,#1153 - Got a packet bigger than \max_allowed_packet\ bytes,got a packet bigger than,got a packet bigger than max_allowed_packed bytes,Got a packet bigger than max_allowed_packet bytes 1153,Got a packet b
