LOAD DATA LOCAL INFILE failure

laskas

Hello everybody,

I've been trying to get this thing to work for more than a week without result. It drives me nuts!

I want to load some textfiles from a windows directory in a mysql table using a php script with the following syntax:

mysql_query (" LOAD DATA LOCAL INFILE 'C:\aa\20020425.01' INTO TABLE transactions FIELDS TERMINATED BY '|' ENCLOSED BY '|' ESCAPED BY '\' LINES TERMINATED BY 'r\n' (shopcode, date, time, tr_code, aa, ref, description, quantity, price, dig) ");

The textfile's data looks like this:

01|03/01/2002|13:45:28|52|1|28167|product description|1|6,75|0,00

The mysql connection is ok, the file exists in the given pathname(fopen & fpassthru work ok) but the data never get into the table and - God knows why - I don't get any error message !!!

If this problem reminds you of something, then I would deeply appreciate your reply.

Anon

Have you tried typing the command directly in the mysql shell? This way you'll be sure to get all the error messages. Also, I remember terminating the lines by '\r\n'

laskas

It sure works through the mysql shell or the phpadmin, but the point is that I need to loop in a whole directory of textfiles, which will not always contain the same number of files. I don't think that the shell program will fit my needs. Anyway, thanks for your kind interest.

laskas

Well, sounds silly, but the problem was with the backslashes I used for the pathname. All I had to do was to use the forward slashes and everything worked ok.