Error when MySQL imports bulk data: (2006, ' MySQL server has gone away ')

Error occurred when MySQL imported data: (2006, ' MySQL server has gone away ')

Solution: The official explanation is that the appropriate increase in the max_allowed_packet parameter allows the client to transfer large data to the server side, allowing the system to allocate more extended memory for processing.

Set max_allowed_packet = 256M (1024*1024*256)

set global max_allowed_packet=268435456;

Use the set global command to modify the value of the Max_allowed_packet, which will expire after restarting MySQL and revert to the default value.

If you want to not restore after reboot, you can open the my.cnf file, add max_allowed_packet = 256M .

Error when MySQL imports bulk data: (2006, ' MySQL server has gone away ')