MySQL import large SQL file error Max_allowed_packet

1. View the current maximum allowable import SQL file size

Show VARIABLES like '%max_allowed_packet% ';

　　

2. How to Modify

1. Permanent entry into force

Modify the My.cnf file

VIM/ETC/MY.CNF (if not found using: MySQL--help | grep my.cnf)

　　　　

2. Temporary entry into force

Run in the MySQL command line

Set Global Max_allowed_packet = 2*1024*1024*10 exit the MySQL command line and log back in.　　　　Show VARIABLES like '%max_allowed_packet% '; See if the next Max_allowed_packet is edited successfully
Note: In method 2, if the MySQL service is restarted, the value of Max_allowed_packet is restored to the default initial value, and the value set on the command line does not take effect.

3. After restarting the MySQL server, this parameter will take effect

MySQL import large SQL file error Max_allowed_packet