Hi all, I'm using Load_File to insert the contents of .doc files into a MySql database running on Windows Server 2003.
For some reason it only seems to work if the file is in the root of the drive and not in a folder -
LOAD_FILE('d:\ALEXANDER Richard.doc') works
LOAD_FILE('d:\wr\data\ALEXANDER Richard.doc') does not work, it just returns NULL.
The file does exist in both cases.
The MySql service is set to logon as the Local System Account.
I'm guessing its something to do with permissions, but other than that I'm lost.
edit : Seems I solved my own problem -
LOAD_FILE('d:/wr/data/ALEXANDER Richard.doc') does work.


LinkBack URL
About LinkBacks
Reply With Quote

