MySql查询大量数据时报错Error Code:1153 Got a packet bigger than 'max_allowed_packet' bytes
来源:互联网 发布:什么是网络通讯员 编辑:程序博客网 时间:2024/09/21 09:26
今天用SQLYog执行数据插入命令,一共3万多条记录吧,导入数据库时提示:Error Code:1153 Got a packet bigger than 'max_allowed_packet' bytes错误提示。
开始没注意,提示一大堆,后来才看见这句
使用SQLyog工具导出MySQL数据时,当数据量大时,导出不会错误,但导入时会出现错误。如果将SQL单独执行会发现是Error Code:1153 Got a packet bigger than 'max_allowed_packet' bytes错误。
对于这个问题可以在my.ini中最后增加一行max_allowed_packet=16M即可(根据实际情况设置)。
注意,在[client]和[mysql]部分增加无效,那个是客户端读取的参数。
0 0
- MySql查询大量数据时报错Error Code:1153 Got a packet bigger than 'max_allowed_packet' bytes
- mysql数据导入时报错【Got a packet bigger than‘max_allowed_packet’bytes】的解决办法
- mysql error code 1153:Got a packet bigger than ‘max_allowed_packet’
- MYSQL error: Got a packet bigger than ‘max_allowed_packet’ bytes
- MYSQL error: Got a packet bigger than ‘max_allowed_packet’ bytes
- navicat 导入sql文件时报错:1153 :Got a packet bigger than 'max_allowed_packet' bytes
- 使用discuz时报错:(1153) 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的问题
- error: 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
- Navicat 导入数据报错 --- 1153 - Got a packet bigger than 'max_allowed_packet' bytes
- Navicat 导入数据报错 --- 1153 - 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错误
- Linux0.11内核进程数据结构
- javascript (二) 支持javascript的几个主流浏览器
- 深入理解js闭包
- C#开发——WinForm应用程序中的ComboBox实现ReadOnly功能
- Chrome插件开发之隐藏页面图片
- MySql查询大量数据时报错Error Code:1153 Got a packet bigger than 'max_allowed_packet' bytes
- MTK Android 菜鸟上手之旅
- Spinner android:entries属性
- ARM板上android系统开机Logo的修改
- hadoop shell 操作指南
- [ACM] poj 1182 食物链(并查集)
- C++ 大数阶乘求取--数组实现代码
- php基础之字符串简单操作
- 这游戏如此吊,它的玩家知道吗-Android游戏《头脑风暴》