MySQL Recovery and data import issues (ERROR 2006 (HY000) at line 1016:mysql server have gone away)

Today in the process of going to work, you need to import a 1.3G database SQL file into the MySQL database, in the execution of the process encountered some problems, execution to half times wrong, error is as follows

ERROR 2006 (HY000) at line 1016:mysql server have gone away

After the error, Baidu looked up the information, presumably because MySQL in the import data when the SQL statement is too long, more than the MySQL max_allowed_packet limit, this can be modified by this

The size of the parameter to adjust:

Set global max_allowed_packet=1024*1024*120;

I am adjusting for 120m size myself

The function of the Max_allowed_packet parameter is to control the maximum length of its communication buffer

There may be some reasons for the timeout, more than the time of wait_timeout, resulting in the occurrence of this problem, the resolution can be resolved by setting the parameters:

Wait_timeout =
Interactive_timeout =

You can adjust your time,

MySQL Recovery and data import issues (ERROR 2006 (HY000) at line 1016:mysql server have gone away)