Home >Database >Mysql Tutorial >修改MySQL导入数据文件大小限制的方案_MySQL
修改MySQL导入数据文件大小限制的方案_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:30:451180browse
bitsCN.com
修改MySQL导入数据文件大小限制的方案
1. Linux中修改my.cnf文件.
max_allowed_packet=500M
2. Window中修改my.ini文件（在安装目录下能找到）
PS：注意这句话加的位置
修改之后保存文件并且重启MySQL服务，可以命令行查看下修改的值是否生效
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL复习笔记II_MySQLNext article：MySQL字段约束null, not null, default, auto_increment_MySQL