title: Importing CSV to MySQL without losing an auto-increasing field's data
body: <p>I imported data from MySQL to a CSV. Now I am trying to import it into another machine's MySQL. But I want to preserve the original auto-increased <code>id</code>'s values.</p>
  
  <p>I tried this:</p>
  
  <pre><code>LOAD DATA INFILE '/tmp/region.csv'
  INTO TABLE regions
  FIELDS TERMINATED BY ','
  ENCLOSED BY '"'
  ESCAPED BY '\\'
  LINES TERMINATED BY '\n'
  IGNORE 1 LINES
  
  (id,name,parent_id,level)
  </code></pre>
  
  <p>But this didn't work. Any help? </p>