Executing a 120mb insert statement

I am trying to run an INSERT statement (from a file.sql - in relation to my post [ How do I load a local .SQL file into MySQL? ]) however the INSERT statement takes up the whole file. It is a single insert stateme开发者_如何学Cnt that is about 120mb in size.

I keep getting this error when running the following command:

Command: mysql -u username -p database < import.sql Error: ERROR 2013 (HY000) at line 28: Lost connection to MySQL server during query

I have no idea how to make this work. I have tried adjusting the max packet size values, still no luck.

You need to increase the max_allowed_packet parameter on the server. See this link for information.