报错内容: There was error(s) while executing the queries .
The query and the error message has been logged at:
C:\Users\beyond\AppData\Roaming\SQLyog\sqlyog.err.
Please click on “Open Error File…” to open the error file.
插入或更新数据量过大,解决办法
(针对 mysql 5.7)
修改 my.ini 配置
max_allowed_packet =4M(默认值)
4M即 4 * 1024 * 1024 = 4194304;
修改完成之后要重启mysql服务。
如果通过命令行修改就不用重启mysql服务。
命令修改:(即时生效)
正确写法:
设置为20M
mysql> set global max_allowed_packet = 2010241024;
或者
mysql> set global max_allowed_packet = 20971520;
退出命令行,再次登陆mysql,运行:
show VARIABLES like '%max_allowed_packet%';
结果是:
±------------------------------------±-------------------------+
| Variable_name | Value |
±------------------------------------±-------------------------+
| max_allowed_packet | 20971520 |
| slave_max_allowed_packet | 1073741824 |
±------------------------------------±-------------------------+
注: 必须重登录行才可以看到更新后的数值
转载至: http://blog.csdn.net/fengyong7723131/article/details/50612312