How to solve the problem of data import reporting error Got a packet bigger than'max_allowed_packet'

This article shows you how to solve the problem of data import error reporting Got a packet bigger than'max_allowed_packet', the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Error reporting in data Import: a problem with Got a packet bigger than'max_allowed_packet'bytes

2 solutions:

1. Temporary modification: > set global max_allowed_packet=524288000; modification # 512m

two。 To modify my.cnf, you need to restart mysql. Www.2cto.com

Add a sentence to the [MySQL] section (if it exists, you can adjust its value):

Max_allowed_packet=10M

The above content is how to solve the problem of data import error reporting Got a packet bigger than'max_allowed_packet'. Have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.