使用discuz时报错:(1153) Got a packet bigger than 'max_allowed_packet' bytes
来源:互联网 发布:新西兰网络签证 编辑:程序博客网 时间:2024/06/05 14:59
使用discuz时报错:
(1153) Got a packet bigger than 'max_allowed_packet' bytes
查了一下,原来是MySQL默认读取执行的SQL文件最大为8M,我这个SQL文件60M,所以执行不过去
解决方法:
在MySQL安装目录下找到文件/etc/my.cnf,搜索[mysqld],在其下面添加一句话
max_allowed_packet=100M
重启MySQL服务
0 0
- 使用discuz时报错:(1153) Got a packet bigger than 'max_allowed_packet' bytes
- MySql查询大量数据时报错Error Code:1153 Got a packet bigger than 'max_allowed_packet' bytes
- navicat 导入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] 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
- mysql数据导入时报错【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
- 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
- 找出ip数据包在网络中经过的路由
- 函数表驱动法
- 《Hadoop学习笔记系列》一.Hadoop基础
- php socket 超时设置
- HTTP协议状态码详解(HTTP Status Code)
- 使用discuz时报错:(1153) Got a packet bigger than 'max_allowed_packet' bytes
- c++多态实现原理
- 【Java】中静态方法如何访问非静态方法和非静态变量
- AndroidStudio指定git的忽略文件
- Qt 总结
- 驱动程序中使用event view记录日志
- 霍夫曼树
- Android仿超级课程表的课程界面设计
- 链队列