title: Importing data from CSV file into MYSQL
body: <p>I am trying to load data into a database table (MYSQL 8.0.28) in my Windows 11 pc through <code>load data local infile</code> command.</p>
  <p>I have gone through the syntax (<a href="https://dev.mysql.com/doc/refman/8.0/en/load-data.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/8.0/en/load-data.html</a>), some problems with trying to import string as date, enabling the import process in the server with the server variable <code>local_infile</code> and the connection variable <code>OPT_LOCAL_INFILE</code>.</p>
  <p>Now when I try to run the script I get:</p>
  <blockquote>
  <p>Error Code: 2. File 'covidDeath.csv' not found (OS errno 2 - No such file or directory)</p>
  </blockquote>
  <p>I want to use relative addresses, and I have copied the file into the directory of the server executable but it is the same.</p>
  <p>Where should I put the data files in order to reference them with a relative address?</p>