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.
Both mysql's are 2.66 versions.
I am now totally confused