title: MySQL Error 29. SQL not using correct file path
body: <p>Working on using the <code>LOAD DATE INFILE</code> syntax to import my csv files into my database. Using windows 10.</p>
  
  <p>Originally when using this syntax I was getting <strong>ERROR 1290</strong> which I resolved by adding: <code>secure-file-priv = "" to the .ini file.</code></p>
  
  <p>I no longer get ERROR 1290 but when i use:</p>
  
  <pre><code>LOAD DATA INFILE 'C:\Users\ovoJa\Downloads\VEN01_562.csv'  
  INTO TABLE    venom  
  FIELDS TERMINATED BY ','  
  ENCLOSED BY '"' 
  LINES TERMINATED BY '\n'
  </code></pre>
  
  <p>I get this ERROR 29: </p>
  
  <blockquote>
    <p>File 'C:\ProgramData\MySQL\MySQL Server 8.0\Data\UsersovoJaDownloadsVEN01_562.csv' not found (OS errno 2 - No such file or directory)</p>
  </blockquote>
  
  <p>Why is it still looking in the Programdata file for the .csv file?</p>