title: Finding MySQL errors from LOAD DATA INFILE
body: <p>I am running a LOAD DATA INFILE command in MySQL and one of the files is showing errors at the mysql prompt.</p>
  
  <p>How do I check the warnings and errors?  Right now the only thing I have to go by is the fact that the prompt reports 65,535 warnings on import.</p>
  
  <pre><code>mysql&gt; use dbname;
  Database changed
  mysql&gt; LOAD DATA LOCAL INFILE '/dump.txt'
      -&gt; INTO TABLE table
      -&gt; (id, title, name, accuracy);
  Query OK, 897306 rows affected, 65535 warnings (16.09 sec)
  Records: 897306  Deleted: 0  Skipped: 0  Warnings: 0
  </code></pre>
  
  <p>How do I get mysql to show me what those warnings are? I looked in the error log but I couldn't find them. Running the "SHOW WARNINGS" command only returned 64 results which means that the remaining 65,000 warnings must be somewhere else.</p>
  
  <pre><code>2 |
  | Warning | 1366 | Incorrect integer value: '' for column 'accuracy' at row 2038
  3 |
  | Warning | 1366 | Incorrect integer value: '' for column 'accuracy' at row 2038
  4 |
  | Warning | 1366 | Incorrect integer value: '' for column 'accuracy' at row 2038
  6 |
  | Warning | 1366 | Incorrect integer value: '' for column 'accuracy' at row 2038
  7 |
  +---------+------+--------------------------------------------------------------
  --+
  64 rows in set (0.00 sec)
  </code></pre>
  
  <p>How do I find these errors?</p>