title: MySQL LOAD DATA Error (Errcode: 2 - "No such file or directory")
body: <p>I am trying to load data into a table of my MySQL database, and getting this error. </p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'C:\Users\Myself\Desktop\Blah Blah\LOAD DATA\week.txt' 
  INTO TABLE week;
  </code></pre>
  
  <p>Reference: <a href="https://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-bulk-data-loading.html" rel="noreferrer">this</a></p>
  
  <p>The path is hundred percent correct, I copied it by pressing shift and clicking "copy path as" and checked it many times. <strong>So any tips on this will be much appreciated</strong>. 
  .
  <strong>My research:</strong> Seeing <a href="https://stackoverflow.com/questions/9149819/mysql-loader-error-ctest-txt-not-found-errcode-2">this</a> answer, I tried by changing <code>C:\Users</code> to <code>C:\\Users</code>. It did not work for me.</p>
  
  <p>Secondly, <strong>is there a way to use some kind of a relative path (rather than an absolute path) here?</strong></p>