in reply to Using SQL LOAD DATA INFILE via CGI

Since your CGI application seems to be on a different box than the database, you have to make sure that both machines can see your upload file. Database functions such as LOAD and UNLOAD are (usually) local to the database server. This will require the database server to be able to see the uploaded file via a network file share (SAMBA).

A workaround for you could be to shell out to a database loader tool that will locally slurp your upload file (on the Window box), and load it into the remote database. Or, you could take a performance hit and perform individual inserts into the table by slurping a line at a time from your file.


Chris
'You can't get there from here.'