load data loses connection

[Jamie Murray]

Hi Guys,
> I am running winxp with mysql 5.0.
> I am attempting to run this statement
> mysql> load data infile "c:\\mysql\\pop.txt" into table population
> (lastname,firstname,age,sickness);
> 
> after waiting about a minute I get
> 
> ERROR 2013 (HY000): Lost connection to MySQL server during query
> 
> and then a microsoft popup reports an error has occurred and asks if  I want
> to send a bug report to microsoft.
> 
> Anyone have any ideas as to what this could be, is there a setting for
> loading data I should be aware of(buffer or timer etc...).
> I initially tested my data file with 200 rows and it worked just fine but
> 1million causes it to fall flat on its face.