【mysql案例】导入报错-ERROR2013(HY000)

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了【mysql案例】导入报错-ERROR2013(HY000)，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1725字，纯文字阅读大概需要3分钟。

内容图文

【现象】 导入MySQL的mysqldump文件时报错，提示ERROR 2013 (HY000) at line xxoo: Lost connection to MySQL serverduring query，导入操作中断退出。 【原因】 要导入的mysqldump文件中insert的values太多，超过了MySQL参数max_allowed_packet的，进而导致

【现象】

导入MySQL的mysqldump文件时报错，提示ERROR 2013 (HY000) at line xxoo: Lost connection to MySQL serverduring query，导入操作中断退出。

【原因】

要导入的mysqldump文件中insert的values值太多，超过了MySQL参数max_allowed_packet的值，进而导致导入操作中断退出。

【解决方法】

调高max_allowed_packet的值：

SQL> set global max_allowed_packet=67108864;

【参考资料】

max_allowed_packet值的范围是1024 ..1073741824，单位是字节。

The packet message buffer is initialized tonet_buffer_length bytes, but can grow up to max_allowed_packet bytes whenneeded. This value by default is small, to catch large (possibly incorrect)packets.

You must increase this value if you areusing large BLOB columnsor long strings. It should be as big as the largest BLOB you want touse. The protocol limit for max_allowed_packet is 1GB. The value should be amultiple of 1024; nonmultiples are rounded down to the nearest multiple.

Whenyou change the message buffer size by changing the value of themax_allowed_packet variable, you should also change the buffer size on theclient side if your client program permits it. The default max_allowed_packetvalue built in to the client library is 1GB, but individual client programsmight override this. For example, mysql and mysqldump have defaults of 16MB and24MB, respectively. They also enable you to change the client-side value bysetting

【后续】可以测试一下 long strings 和 BLOB column

内容总结

以上是互联网集市为您收集整理的【mysql案例】导入报错-ERROR2013(HY000)全部内容，希望文章能够帮你解决【mysql案例】导入报错-ERROR2013(HY000)所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端