Import a comma delimited file directly into mySQL by query? (File not found.)

use `free.wifi.locations`;
load data local infile '\BusinesseswithfreeWiFi.csv' into table locations
fields terminated by ','
lines terminated by '\n'
(lat, lng, name, memo);

My installation of mySQL is on a windows machine. I tried placing the file into the home directory which is C:\users\myuser. I also tried using the direct path to the file which is something like E:\jobs\wifilocations\BusinesseswithfreeWiFi.csv to no avail. My error code is

Error Code: 2. File 'BusinesseswithfreeWiFi.csv' not found (Errcode: 2)

I am so sure this can work. Does anyone know why mySQL workbench can't find my file?

Give it the full file path, make sure whatever user you're running mySQL with has permissions to the file, and permissions to traverse into the directory where the file is located.

Also make sure your server is configured to accept the file:

MySQL does not want '\' as a folder separator, it wants a '/' (more Linux like). That was the key to the whole thing. Now I just need to extend my fields a little bit to stop some of the data from being truncated.