Error Code: 2006 – MySQL server has gone away

What are the eight life cycle hook functions of Vue>>>

Copyright notice: please indicate the original address https://blog.csdn.net/u013032788/article/details/46564257

The reason for this problem is that the file is too large when importing data

Solutions:
1

1. For Linux system, find the configuration file my.cnf and modify it to a larger value in [mysqld]:

max_ allowed_ packet=6000000M

wait_ timeout=600000

interactive_ timeout = 600000

(it means that the maximum allowable packet size is 16m, and the waiting time-out/activity failure time is 600000 seconds)

2. If it is a Windows system, the general configuration file is my.ini

3. If the configuration file cannot be found, you can run the following statement:

SET GLOBAL max_ allowed_ packet=6000000;

4. Remember to restart mysql

============================================================================

Let’s learn and grow together

Program development group Linux, C: 368848856
Shanghai web development group PHP/ASP: 452703835 (beginner)
verification information: second in charge

Similar Posts: