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
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.