MySQL Import SQL script error: 2006-mysql server has gone away

To some small script that rarely complains, but recently imported a 10+m SQL script, but repeated the error:

Error occured at:2014-03-24 11:42:24
Line no.:85
Error Code:2006-mysql server has gone away

Finally found the reason, the original is MySQL import mass data exceeded the default allow the largest packet so prompted 2006-mysql server has gone away

So find my.cnf, in [mysqld] add:

The code is as follows	Copy Code
max_allowed_packet=300m wait_timeout=200000 Interactive_timeout = 200000

Maximum allowable packet 300M, wait timeout/activity failure often 200,000 seconds, restart MySQL

The code is as follows	Copy Code
[Root@lizhong 20140323]#/etc/init.d/mysqld Restart Shutting down MySQL .... success! Starting MySQL. success!

Re-import again, all normal!