解决MYSQL的错误:Got a packet bigger than 'max_allowed_packet' bytes
来源:互联网 发布:ug4.0编程加工步骤 编辑:程序博客网 时间:2024/06/05 17:32
MySQL 5.1开始遇到的信息包过大问题,当用客户端导入数据的时候,遇到错误代码: 1153 - Got apacket bigger than 'max_allowed_packet' bytes,数据库终止了数据导入的操作。
原因分析:MYSQL限制了每次执行插入操作的数据最大值,超过最大值则报以上错误。
深度研究后发现:
数据库客户端和数据库服务器端器均有自己的max_allowed_packet变量,因此,如你打算处理大的信息包,必须增加客户端和服务器上的该变量配置数值。
一般情况下,服务器默认max-allowed-packet为1MB,客户端的max-allowed-packet为16MB。
MYSQL端修改max-allowed-packet数值的方法是:
在MYSQL的配置文件my.ini中加入:
[mysql]
max_allowed_packet=16M
然后重启MYSQL。
0 0
- 解决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错误
- MySQL Got a packet bigger than 'max_allowed_packet' bytes错误
- MySQL Got a packet bigger than 'max_allowed_packet' bytes错误
- windows MySQL 报“Got a packet bigger than 'max_allowed_packet' bytes”错误,解决过程.
- windows MySQL 报“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
- mysql-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”
- Got a packet bigger than ‘max_allowed_packet’ bytes的解决方法
- MySql 错误 Err [Imp] 1153 - Got a packet bigger than 'max_allowed_packet' bytes
- MySql 错误 Err [Imp] 1153 - Got a packet bigger than 'max_allowed_packet' bytes
- 【Natural Language Processing】社区问答系统中的comment分类
- Centos Linux Anaconda Python Pip安装、启动和环境配置
- FCN全卷积网络上采样理解
- ListView的点击事件与子控件点击冲突的解决
- 内存的构造和变量占用的字节数
- 解决MYSQL的错误:Got a packet bigger than 'max_allowed_packet' bytes
- BZOJ 5049. 【GDOI2017模拟一试4.11】腐女的生日
- Java实例-输入年月日完成以下判断
- Proud Merchants HDU
- 怎样才能将刘徽割圆术动画演示
- (原创)详解共享参数存储
- php 替代被弃用函数的
- PHP过滤敏感词
- navicat无法连接数据库