I have spent almost two weeks trying to figure this out.....
Web searches have have yielded confilcting advice....
I am using PHP and MySQL. After successfully making a connection, I am able to do a "LOAD DATA LOCAL". This loads data from a ".csv" file on the MySQL Server.
Now I want to load data from a file on the 'client' instead. Some web searches say this is not possible. Others say you need to set permissions correctly first.
My read (from the MySQL and PHP documentation) is that this is possible using "LOAD DATA INFILE". Specifically, documentation says that the "LOAD DATA LOCAL" differs from "LOAD DATA INFILE" in that the the first is for files found on the MySQL server (and this is how I am able to do just that). The "LOAD DATA INFILE" seems to be for data files (".csv") found locally on the client.
Is this true?
I have fought my way past the "access denied" and "SQL Syntax" errors. The message I am stuck with now is
"Can't get stat of 'c:\temp.csv' (Errcode: 2)".
At first, I thought I was on my way to solving the problem because "access denied" was no longer the error. But I am getting the message from two different client machines (one that I have granted permissions for, and one that I have not).
Please. I am losing my mind on this one.....
-Bill
