MYSQL Timeout Issue

[prav5110]

HI Guys,

I am trying to import a csv file(78mb) into mysql table. after a few seconds I get error 2013: connection to the server lost. I am able to break the file in parts and import to the table, but am not able to do so all at once. I guess I would have to change the server timeout option. Could you advise how to do that?

Thanx

 

[rzs0502]

By default, the server closes the connection after 8 hours if nothing has happened. You can change the time limit by setting the wait_timeout variable when you start mysqld.

Another common reason to receive the MySQL server has gone away error is because you have issued a ``close'' on your MySQL connection and then tried to run a query on the closed connection.