LOAD txt file DATA INFILE issues
Use LINES TERMINATED BY '\n' or just leave it out altogether.  '\n' is the linefeed character on Linux, and with '\n\r' it will never see a linefeed, so the entire file looks like one long line, and you told it to ignore 1 line, so it sees nothing to insert. 

You also need  "OPTIONALLY ENCLOSED BY '"'.  Try something like this:

mysql&gt; LOAD DATA LOCAL INFILE 'routes.txt' 
    INTO TABLE routes FIELDS TERMINATED BY ','
      OPTIONALLY ENCLOSED BY '"' IGNORE 1 LINES;
Query OK, 3 rows affected (0.00 sec)
Records: 3  Deleted: 0  Skipped: 0  Warnings: 0

mysql&gt; SELECT * FROM routes;
+----------+--------+-------------+----------+
| route_id | origin | destination | distance |
+----------+--------+-------------+----------+
|        1 | ABE    | ATL         |  692.000 |
|        2 | ABE    | DTW         |  425.000 |
|        3 | ABE    | ORD         |  655.000 |
+----------+--------+-------------+----------+
3 rows in set (0.00 sec)


Obviously, leave off LOCAL if using a file on a remote server and be sure the file is readable by MySQL.