Home >Database >Mysql Tutorial >数据导入报错：Got a packet bigger than‘max_allowed_packet’_MySQL
数据导入报错：Got a packet bigger than‘max_allowed_packet’_MySQL
- WBOYOriginal
- 2016-06-01 13:42:43957browse
bitsCN.com
数据导入报错：Got a packet bigger than‘max_allowed_packet’bytes的问题 2个解决方法： 1.临时修改：mysql>set global max_allowed_packet=524288000;修改 #512M 2.修改my.cnf，需重启mysql。 在 [MySQLd] 部分添加一句（如果存在，调整其值就可以）： max_allowed_packet=10M 作者 lafang2009 bitsCN.com
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命令行--导入导出数据库_MySQLNext article：MYSQL外键(Foreign Key)的使用_MySQL