title: Import Big csv file into mySql
body: <p>I am trying to import 300 mg csv file into mySql table. I am using this command:</p>
  
  <pre><code>LOAD DATA INFILE 'c:/csv/bigCSV.csv' IGNORE 
  INTO TABLE table
  FIELDS TERMINATED BY ',' 
  LINES TERMINATED BY '\r\n'
  IGNORE 1 LINES
  </code></pre>
  
  <p>And it works great with small files (1 mg and so on), but when I try to load a big file like the one mentioned, MySql Workbench (which I use to execute my queries) runs the command, everything ok and green but 0 rows affected. No changes at all in the table.</p>
  
  <p>I am 10000% sure that the table is ok because when I take a portion of that file, eg 1mg and load it into the same table it works fine.</p>
  
  <p>Did anyone had this kind of problems? </p>
  
  <p>Thank you.</p>