Really hoping that someone can point me in the right direction with this, as I seem to have coded myself into a corner.
I have written a script that pulls data from my own database and inserts it into a database on the server that it is being run on (people I work with install this on their servers to keep our data synchronised).
At the moment, the script makes gets a copy of the CSV file from the main server and saves it locally. It then uses LOAD DATA INFILE to insert this into the local database.
I have now found out that most hosting accounts don't give the FILE permission as standard so the script fails for these users.
Can anyone suggest a way around this? Not neccessary looking for a step by step solution (wouldn't compain though), but some idea of where to look / what to look at would really be appreciated.
Thanks in advance.
Nearly forgot :: Running mysql
