MySQL Import large file error (MySQL server has gone away (Error 2006))

Objective

When we import MySQL data, the MySQL client suddenly error: MySQL server has gone away (Error 2006)

In this case, the idea is to adjust MySQL to allow the size of the import package.

There are two ways to set it up:

1. Modify the MySQL my.inf configuration file (unit B, set to 800M here): max_allowed_packet= 2*1024*1024*400

2. Log in to MySQL command line: Set global max_allowed_packet= 2*1024*1024*400

As shown

MySQL Import large file error (MySQL server has gone away (Error 2006))