load data infile only loads last line

[Kevin L]

Hi there,

I have a text file that I am using a very simple load infile command but it seems to load only the last line.

LOAD DATA INFILE "$filename"
REPLACE INTO TABLE ticker_info
LINES TERMINATED BY '\r\n';

I opened up the text file in a text editor and confirmed that each line ends with a carriage return and a linefeed character.

Any help would be greatly appreciated.