Solve the problem of \\"MySQL server has gone away\\" when importing database

Today, when I was helping a netizen relocate a server, the database always used mysql to import the backup database. The error "ERROR 2006 (HY000) at line 2214: MySQL server has gone away" appeared. It had always been there before. There is no problem in importing using this method. Judging from the error prompt, it is estimated that the parameters set are too small and the database is relatively large. Seeing that its database is about 2GB, it should exceed the resource limit.

To solve this problem we need to modify the default my.cnf configuration file. Change the default "max_allowed_packet\\" parameter value to 1M. Here I directly change it to 32M. Try a larger value.

This netizen is using the WDCP system. Here he directly finds the corresponding my.cnf file and then makes modifications in two places.

Finally, after the modifications are saved, restart the WEB and then import mysql into the database without error.

Recommended site searches: multi-IP station group server, free proxy IP, domain name registration query, Hong Kong IP, view IP address, rent a server, the cheapest cloud server, domain name service provider, asp.net host, Chinese domain name,