mysql Packets larger than max_allowed_packet are not allowed
来源:互联网 发布:exif信息查看器 mac 编辑:程序博客网 时间:2024/06/01 07:49
通过MySQL的"load data local infile"语句将一个文本文件中的内容导入到数据库中,出现异常:“Packets larger than max_allowed_packet are not allowed” 。
MySQL的一个系统参数:max_allowed_packet,其默认值为1048576(1M)
查询:show VARIABLES like '%max_allowed_packet%';
解决办法:
修改此变量的值:
在MySQL安装目录下的my.ini文件中的[mysqld]段中的"max_allowed_packet = 1M",如更改为20M(如果没有这行内容,增加一行),保存,重起MySQL服务。现在可以load大于1M的文件了。可以具体根据你的文本文件大小来设定这个值。
- Packets larger than max_allowed_packet are not allowed
- mysql Packets larger than max_allowed_packet are not allowed
- MYSQL报错“Packets larger than max_allowed_packet are not allowed”
- Mysql 报错Packets larger than max_allowed_packet are not allowed
- - s4s-elt-character: Non-whitespace characters are not allowed in schema elements other than 'xs:app
- sql错误1301 Result of CONCAT() was larger than max_allowed_packet(1024)-truncated
- systems do not support files larger than 2 GB
- ORA-01438处理方法 value larger than specified precision allowed for this column
- ORA-01438: value larger than specified precision allowed for this column
- ora-01438:value larger than specified precision allowed for this column
- 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 error: Got a packet bigger than ‘max_allowed_packet’ bytes
- MYSQL error: Got a packet bigger than ‘max_allowed_packet’ bytes
- mysql error code 1153:Got a packet bigger than ‘max_allowed_packet’
- MySQl Got a packet bigger than ' max_allowed_packet' bytes
- Mysql提示 “ Got a packet bigger than 'max_allowed_packet' bytes”
- Android多版本兼容示例
- 深入浅出Linux设备驱动之字符设备驱动程序
- 3G之Android学习第一章节<<开发环境搭建>>
- 直接修改别人jar包里面的class文件 工具:jclasslib
- php输出脚本压缩
- mysql Packets larger than max_allowed_packet are not allowed
- 开发者需知:优秀程序设计的18大原则
- U-Boot顶层Makefile分析
- 杂项9
- 在用gui登录时,提示00,791的提示信息;口令无法在最初&天内更改
- 1-100不重复随机数的另一种思路
- Android 程序错误处理全局处理-捕获全局异常
- c++代理类
- 用Multisim分析二阶低通滤波器电路