MySQL and INFILE on Ruby...

You do need to escape the \r\n but you also need to escape the " you have in the string so...

"LOAD DATA LOCAL INFILE 'C:\\test.csv' INTO TABLE db_test.tbl_testing FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\\r\\n'(data1,data2)"

(Note that would all be on one line, my email wraps it)

Should work, I use the same thing in my migrations with no problems.