title: Load data infile, difference between Windows and Linux
body: <p>I've a file which I need to import to MySQL table. Here's my command</p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'C:\test.csv'
  INTO TABLE logs
  fields terminated by '|'
  LINES terminated BY '\n'
  </code></pre>
  
  <p>This looks fine in Windows, but in Linux it inserts only the first row and generates an error in log file</p>
  
  <pre><code>LOAD DATA LOCAL INFILE '/home/myuser/test.csv'
  INTO TABLE logs
  fields terminated by '|'
  LINES terminated BY '\n'
  </code></pre>
  
  <p>What I need to change in Linux? </p>