title: Why can I not locate a .csv file when using LOAD DATA LOCAL INFILE?
body: <p>I'm using MySql version 5.6 on a Mac running MAMP.  I've set my document root to user/Desktop/Sites/Rankings.  I'm trying to upload a CSV file into a table using the following code:</p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'teams.csv' INTO TABLE Teams
  FIELDS TERMINATED BY ','
  LINES TERMINATED BY '\r'
  IGNORE 1 LINES
  (team_id, team_location, team_name, team_abbrv);
  </code></pre>
  
  <p>I keep getting the following error message:</p>
  
  <pre><code>ERROR 2 (HY000): File 'teams.csv' not found (Errcode: 2 - No such file or directory)
  </code></pre>
  
  <p>I've tried changing a bunch of things based on research done on this site with no luck.  I've confirmed read/write permissions on the file and and made sure local_infile is ON.  I'm starting to wonder if I'm not pointing in the right direction.  When I use LOCAL, does that mean I should be putting my .csv file in the same document root file (Rankings) that I've set up in MAMP?  That's what I've done, but it still doesn't seem to be working.  I'm going crazy!  Thank you for the help.</p>