[SQL] 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
来源:互联网 发布:暗黑2 mac 编辑:程序博客网 时间:2024/05/21 03:29
mysql 在导入较大的数据的时候会出现当前这种情况,这是数据库多导入的数据进行了限制。可能是大小限制具体是什么就不知道了
可以在sql 中运行几句话就能解决这些问题。
SET GLOBAL max_allowed_packet=1000000000;
SET GLOBAL net_buffer_length=1000000;
有可能还要运行一下这句
flush privileges 这是重启权限设置
0 0
- [SQL] 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
- Got a packet bigger than 'max_allowed_packet' bytes
- Got a packet bigger than 'max_allowed_packet' bytes
- Got a packet bigger than 'max_allowed_packet' bytes
- 1153 - Got a packet bigger than 'max_allowed_packet' bytes With statement
- sql query error, 1153, Got a packet bigger than 'max_allowed_packet' bytes
- navicat 导入sql文件时报错:1153 :Got a packet bigger than 'max_allowed_packet' bytes
- mysql-Got a packet bigger than ‘max_allowed_packet’ bytes
- error: Got a packet bigger than ‘max_allowed_packet’ bytes
- MySQL 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的解决方法
- MYSQL error: Got a packet bigger than ‘max_allowed_packet’ bytes
- MYSQL error: Got a packet bigger than ‘max_allowed_packet’ bytes
- MySQl Got a packet bigger than ' max_allowed_packet' bytes
- Mysql提示 “ 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问题排除
- 开始自己的写博之旅
- MFC光标移到到控件上设置为手形
- convexHull函数 取得凸包包含区域图像
- iOS--CocoaPods的安装与使用记录
- findstr
- [SQL] 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
- 浏览器兼容position 定位层级关系
- APP端webview自动播放视频
- [iOS]APP代码实践:建立一个辅助的APP类,减少对AppDelegate的修改
- maven项目使用外部tomcat7并进行远程热部署
- 正确地设置安卓通知栏图标尺寸
- Python继承与多继承
- 语音质量评价
- CentOS学习笔记之<虚拟机能ping通同一网关的其他机器,ping不通主机>