title: More information on SQL error
body: <p>I'm trying to import a CSV file into a table of my database, however I'm getting an error.</p>
  
  <p>Here is the query :</p>
  
  <pre><code>LOAD DATA INFILE '/shr/transfers.txt' INTO TABLE transfers 
  FIELDS TERMINATED BY ',' 
  LINES TERMINATED BY '\n' 
  IGNORE 1 LINES 
  (from_stop_id, to_stop_id, @dummy, transfer_time); 
  </code></pre>
  
  <p>However it raises me the following error :</p>
  
  <blockquote>
    <p>ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails
    (`reseau_ratp`.`transfers`, CONSTRAINT `fk_tsi` FOREIGN KEY
    (`to_stop_id`) REFERENCES `stops` (`stop_id`))</p>
  </blockquote>
  
  <p>Is there any way I can get the line of the <code>.txt</code> file where this query is failing ?</p>