LOAD DATA LOCAL INFILE "C:/TGR26163P.csv" INTO TABLE L26163 FIELDS TERMINATED BY ',';
Using the above I am receiving "file __not found Errcode:2"
I used the file with out the "LOCAL" to load a database on my machine, but when I go to the server, I get the error message.
The file is on my local C: drive. I have tried forward slashes, backslashes, double backslashes, single quotes, double quotes. I have used different combinations of caps and no caps, nothing seems to avoid "file 'C:/TGR26163P.csv' not found.
The full script includes CREATE and DROP commands that work perfectly on my local copy of mysql.
You are correct I am trying to load the file to a remote server. I already loaded it to my server on windows and it worked perfectly. I added the LOCAL and tried the remote server and it would not work. The script has a DROP AND A CREATE which work perfectly on the remote server.
I have tried each of the following to no avail:
LOAD DATA LOCAL INFILE "C:\\TGR26163.csv" INTO TABLE L26163 FIELDS TERMINATED BY ',';
LOAD DATA LOCAL INFILE "C:/TGR26163.csv" INTO TABLE L26163 FIELDS TERMINATED BY ',';
I have replaced the double quotes with single quotes. I have use different capitalization schemes for the filename.