[TriLUG] MySQL

[Mark Freeze]

I have a text file where the data fields are delimited by a hex 0A and the
records are terminated by hex 0C 0A.  I am issuing the command

mysql> LOAD DATA LOCAL INFILE '/home/mark/del.txt' INTO TABLE pif_del
->FIELDS TERMINATED BY '\n'
->LINES TERMINATED BY '\f\n';

and it only imports the first record from a file of 2850 records.

I manually changed all 0A to 09 and all of the 0C to 0A and then sucessfully
imported the entire file with

mysql> LOAD DATA LOCAL INFILE '/home/mark/del_a.txt' INTO TABLE pif_del
->FIELDS TERMINATED BY '\t'
->LINES TERMINATED BY '\n';

On the first file, is there something I am missing to get it to import all
records?

Thanks,
Mark.