MySql错误1153 – max_allowed_packet

快要下班的时候给公司做数据库数据复制Mysql抽风了;试了好几次Mysql一直都错误提示1153 – Got a packet bigger than ‘max_allowed_packet’ bytes With statement: 刚开始刚以为是服务端限制住了;网上查询得知。是客户端max_allowed_packet设置的不够大

1153 - Got a packet bigger than 'max_allowed_packet' bytes With statement: 

遇到错误1153 – max_allowed_packet 请执行Sql语句

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

转载请注明来源:新一 » MySql错误1153 – max_allowed_packet

赞 (0) 评论 (0) 分享 ()

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址