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:
- ERROR 2006 (HY000): MySQL server has gone away No
- Error while sending query packet in PHP runtime
- [reprint] extjs sets the timeout of Ajax request
- MySQL external import data error [How to Solve]
- Sqlog recovery database error solution [error code: 2006 – MySQL server has gone away]
- [Solved] MYSQL:1153 Got a packet bigger than ‘max_allowed_packet’ bytes
- [Solved] MYSQL:1153 Got a packet bigger than ‘max_allowed_packet’ bytes
- Mysql import Error Code: 2013 – Lost connection to MySQL server during query
- [Solved] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=20131)
- [Solved] Windows10 Export Datas to MySQL Error: 2006 – MySQL server has gone away