I am trying to use a large query I have written and I am not having much luck...
Basically I need to have some tables updated via cron so I am writing a series of queries in an sql file that will insert downloaded data at scheduled intervals...
In the past, and now, I can use phpMyAdmin to load these text files by using their Upload file and insert method.
However, when I download the zip files and they get unzipped to my webserver, the sql server, being on a different host of the cluster, cant see them through my absolute path.
When I use phpMyAdmin the following query works
LOAD DATA LOCAL INFILE .........
This is because the file gets uploaded to the sql server.
If I run the same query using a path on my server, obviously it doesnt see the file...
If I use
LOAD DATA INFILE.....
Without local, it seems that it might be able to see the file, but I get an access denied message. Im assuming this means my host doesnt want me to do this.
Basically what I need to know is, with clustered hosting what is the best way for my SQL server to see a file on my webserver so that I can perform this database update?
