MySQL when importing large database, error Error 2006 (HY000): MySQL server has gone away

Or, the error message:

ERROR 2005 (HY000): Unknown MySQL Server Host ' 10997107101114 ' (0)
ERROR:
Can ' t connect to the server

No connection. Trying to reconnect ...

=======================

Workaround:

Mysql> show global variables like ' max_allowed_packet ';

mysql> set global max_allowed_packet=1024*1024*16;

Mysql> show global variables like ' max_allowed_packet ';

=======================

Unknown command ' \ n ' This error occurs when importing a database, does it matter?

DOS Error error at line xxx:unknown command ' \ n ';

This situation is generally caused by the wrong character set, if the database is UTF8 encoded, then
When MySQL is imported
MYSQL-UROOT-PPASSWD <d:\aa.sql--default-character-set=utf8
Also if the database is GBK, the import
MYSQL-UROOT-PPASSWD <d:\aa.sql--DEFAULT-CHARACTER-SET=GBK

MySQL when importing large database, error Error 2006 (HY000): MySQL server has gone away