Thanks Drew
Yes it is unix and I get the same with
mysql> load data infile '/www/vhtdocs/pet.txt'
-> into table kennels
-> fields terminated by ','
-> enclosed by '"'
-> lines terminated by '/r'
-> (name, address1, address2, town, county ,postcode ,bustype ,telephone
-> ,fax);
ERROR 13: Can't get stat of '/www/vhtdocs/pet.txt' (Errcode: 2)
Any ideas
Thanks for your help
> -----Original Message-----
> From: Drew M Hahn [mailto:dhahn@stripped]
> Sent: 01 April 1999 21:21
> To: Jon Halton
> Cc: mysql@stripped
> Subject: Re: Basic Data Import Query
>
>
> Sure wish I knew what system you are running this on. If it is UNIX,
> those slashes should be forward / slashes and not backward \ slashes.
>
> --drew
>
> On Thu, 1 Apr 1999, Jon Halton wrote:
>
> > I have a data file of about 1100 records I am trying to load
> into a number
> > of columns of a mysql database I am using the following syntax:
> >
> > mysql> load data infile '\www\vhtdocs\pet.txt'
> > -> into table kennels
> > -> fields terminated by ','
> > -> enclosed by '"'
> > -> lines terminated by '/r'
> > -> (name, address1, address2, town, county ,postcode ,bustype ,telephone
> > ,fax)
> > -> ;
> >
> > and get the error
> >
> > ERROR 13: Can't get stat of '\www\vhtdocs\pet.txt' (Errcode: 2)
> >
> > It seems to be having problems finding the file. Where on the
> server would
> > it be looking? Where would the file normally be saved?
> >
> > Also is there any other problems you can see with the syntax I
> have used?
> >
> > An example entry of the file is as follows:
> >
> > "abc kennels","hill farm","","Newcastle","Tyne & Wear","NE7
> 7LZ","Boarding
> > Kennels","0191 2550000",""
> >
> > each line is terminated by a carrige return
> >
> > Thanks for your help.
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > Please check
"http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread1292@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
