title: LOAD DATA INFILE is skipping ALL rows and no warnings
body: <p>I looked for a similar question but I could not find  a magic answer....so I'm hoping I'll find one now as this is driving me crazy! </p>
  
  <p>I was going great guns with importing CSV data into MySQL...and <strong>now suddenly I'm getting nothing but skipped records</strong>. I ought to mention that I have been doing lots of deleting records (just experimenting really as I'm learning about MySQL and building my first database) so I've been chopping and changing the data including lots of copy/pasting in Excel, just in case any of this may be causing the trouble. </p>
  
  <p>An example here, where I chopped the CSV down to just 2 records:</p>
  
  <pre><code>GENRE_NAME
  Classic Rock
  Electronica
  </code></pre>
  
  <p>The query to load the data:</p>
  
  <pre><code>LOAD DATA INFILE 'Music_All_2.csv' IGNORE INTO TABLE genres COLUMNS TERMINATED BY ',' ESCAPED BY '\\' LINES TERMINATED BY '\r' IGNORE 1 LINES (genre_name);
  Query OK, 0 rows affected (0.00 sec)
  Records: 2  Deleted: 0  Skipped: 2  Warnings: 0
  </code></pre>
  
  <p>And the table is empty (so it's not skipping them due to them already existing):</p>
  
  <pre><code>select * from genres;
  Empty set (0.00 sec)
  </code></pre>
  
  <p>Finally, here's the <code>SHOW CREATE TABLE genres</code> output:</p>
  
  <pre><code>genres | CREATE TABLE `genres` (
  `genre_pk` tinyint(2) unsigned NOT NULL AUTO_INCREMENT,
   `genre_name` varchar(90) NOT NULL,
    PRIMARY KEY (`genre_pk`),
   UNIQUE KEY `genre_name` (`genre_name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=255 DEFAULT CHARSET=latin1 |
  </code></pre>
  
  <p>Thank you in advance to the solver of my problem, there is sooooo much I don't know - it's fun learning but frustrating at the same time!</p>