Mysql Data Import prompt MySQLserverhasgoneaway Solution

MySQLserverhasgoneaway prompted when I used mysql to import data yesterday. This means that the server is down, but after a while, I think it will be because the data packet is too big, later, Baidu found a solution.

Mysql server has gone away was prompted when I imported data using MySQL yesterday. This means that the server has crashed, but after a while, I thought it would be because the data packet is too big, later, Baidu found a solution.

Cause

Max_allowed_packet is too small. Increase max_allowed_packet

Solution

In the my. cnf file, modify

Max_allowed_packet should be larger and then imported.