import txt problem

[Anon]

Hi all...

I am trying to import a simple txt comma delimited file into mysql using the load data infile command. However, when I run the command ... for some reason it will not read the txt file. The message I'm getting is something like

LOAD DATA LOCAL INFILE "C:\thefile.txt"
INTO TABLE thedbtable
FIELDS
TERMINATED BY ','
ENCLOSED BY '"'
(aaa,bbb,ccc);

ERROR: File 'C:\thefile.txt' not found

am I missing something here? Or not doing something obviuos?

Any help is always appreciated in advance

thanks

[jordan]

First, of all, MySQL has its roots in unix, and expects you to use forward slashes in paths, e.g. "/thefile.txt" .. second, rather than typing the whole (absolute) path, it's often easier to put the file you're reading into your database's data directory. For example, if my database was called "jordan", the data directory for that database, on my system, would be "c:\mysql\data\jordan", and if I put the file in that directory, I could just pass the relative path, simply "thefile.txt", to MySQL. Make sense? There's a whole section in the MySQL manual on the LOAD DATA INFILE command -- check it out.