rule 发表于 2016-10-19 09:16:20

mysql导入数据报错Got a packet bigger than 'max_allowed_packet' bytes

  
  用sql导入数据时报错
  Got a packet bigger than 'max_allowed_packet' bytes
  
  解决办法
  1.临时解决:
  mysql>set global max_allowed_packet=16384; #16M
  
  2.修改配置文件my.ini 或my.cnf
  有就修改,没有就在最后一行加入,值可适当调整
  max_allowed_packet=16M
  
页: [1]
查看完整版本: mysql导入数据报错Got a packet bigger than 'max_allowed_packet' bytes