I am using Mysqladmin version 1.4 for windows xp.  I am using the
command "load data infile "pet.txt" into table pet".  You all know the
tutorial.  The problem is it keeps telling me there is no file.  I
tried "load data local infile......" also and it says no file, i have
tried saving the file in several different folders.  Anyone tell me
what is up here?

---

Request for Question Clarification by sgtcory-ga on 19 Jun 2003 12:06 PDT

Hello Jimmy,

Which version of MySql are you using?

Thanks,

SgtCory

---

Clarification of Question by jimmyjrosu-ga on 19 Jun 2003 12:54 PDT

Please excuse my inability to tell you the exact version as I am not
at home and will not be until sunday but it is the most recent stable
version for windows listed on the mysql website.  Thank you.

---

Request for Question Clarification by sgtcory-ga on 19 Jun 2003 14:30 PDT

Great.

When you get a chance, can you post the exact same command you are
using, to include all 'FIELDS TERMINATED BY' and 'ENCLOSED BY'
information?

Thanks in advance -

SgCory

Stupid question perhaps -
What happens if you supply an absolute path to the file?

(instead of just using a relative path)

I have tried "load data infile C:\mysql\pet.txt.........."  and I get
an error as well

did you try doubling the \ character?  c:\\mysql...

*The `\' directory character*
     Pathname components in Win95 are separated by `\' characters,
     which is also the escape character in *MySQL*.  If you are using
     `LOAD DATA INFILE' or `SELECT ... INTO OUTFILE', you must double
     the `\' character or use Unix style filenames `/' characters:
          LOAD DATA INFILE "C:\\tmp\\skr.txt" INTO TABLE skr;
          SELECT * INTO OUTFILE 'C:/tmp/skr.txt' FROM skr;

greco-ga,
if you would like to post your comment as an answer, that will be
accepted, it worked.  Thanks!