From: Date: January 15 2004 10:09pm
Subject: load data loses connection
List-Archive: http://lists.mysql.com/win32/13141
Message-Id: <004901c3dbab$e1b8a190$4373a38e@jmurray>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0046_01C3DB8E.8B4D8C20"

------=_NextPart_000_0046_01C3DB8E.8B4D8C20
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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);
>=20
> after waiting about a minute I get
>=20
> ERROR 2013 (HY000): Lost connection to MySQL server during query
>=20
> and then a microsoft popup reports an error has occurred and asks if  =
I want
> to send a bug report to microsoft.
>=20
> 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.

------=_NextPart_000_0046_01C3DB8E.8B4D8C20--