MySQL External import data error

Problem: Export database from server to SQL, import Local database error error Code:2006-mysql server is offline

Workaround:

(1) This problem is due to MySQL default max_allowed_packet too small, modify the larger can

Max_allowed_packet = 100M
In addition, you can increase the number of two parameters to expand the corresponding time
interactive_timeout=28800000
wait_timeout=28800000

(2) View current configuration
Show VARIABLES like '%max_allowed_packet% ';

(3) Enter MySQL server to modify this configuration
Run in the MySQL command line
Set Global Max_allowed_packet = 2*1024*1024*10 (parameter can be set a bit larger)
Then shut down this MySQL server link and then enter.
Show VARIABLES like '%max_allowed_packet% ';
See if the next Max_allowed_packet is edited successfully

(4) Import the data again to resolve the problem.

MySQL External import data error