使用mysqlbinlog报Packet too large的问题
来源:互联网 发布:爱淘宝 1元红包 编辑:程序博客网 时间:2024/06/05 05:08
在使用mysqlbinlog进行恢复时遇到如下错误:
ERROR 1153 (08S01) at line 1304713: Got a packet bigger than 'max_allowed_packet' bytes
当然在使用sql文件导入数据时也可能会遇到这个问题。
在my.cnf中加入:
[mysqld]
max_allowed_packet = 1000M
注意max_allowed_packet最大值为1G。
如果已经将server端的max_allowed_packet改为1G,仍然报错,那么你可能需要在mysql客户端程序上加入参数:
mysql --max_allowed_packet=32M < a.sql
mysql客户端程序默认的max_allowed_packet为16MB。
- 使用mysqlbinlog报Packet too large的问题
- 在Ubuntu/Linux环境下使用MySQL:解决com.mysql.jdbc.PacketTooBigException: Packet for query is too large的问题
- 对于Packet for query is too large(mysql写入数据过大) 问题的处理
- 对于Packet for query is too large(mysql写入数据过大) 问题的处理方法二
- 解决MySql Error: Packet for query is too large... 问题
- MySQL Packet for query is too large 问题及解决方案
- mysql中Packet for query is too large的解决方案
- 使用last报Value too large
- Tomcat 报错:Packet for query is too large (12238 > 1024). You can change this value
- Mysql报Packet for query is too large (1040 > 1024)错误
- MYSQL Packet for query is too large
- Packet for query is too large
- MYSQL Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- 修改注册表实现禁用/启用USB
- XSLT
- 元旦快乐
- 2009年的最后一天,辞旧迎新!
- wildcard notdir patsubst
- 使用mysqlbinlog报Packet too large的问题
- JavaScript 基础技巧(1)
- 2009,你收获了什么?
- 触发器的使用!
- c#面试题目集锦
- input type="file" 样式的模仿
- [技巧靠点点滴滴的积累] Ubuntu 开发代号、命名方式及其他相关.
- 理解EnterCriticalSection 临界区
- 北京出手四万亿的经济分析