LOAD DATA LOCAL INFILE

[monicaz]

I have site on Ensim Linux.. Trying to implement php code which loads data using this statement.

 

(basepath is set to /var/www/html).. in an include file

$infile = $config[\'basepath\'] .\'/admin/test.txt\';

$sql=\"LOAD DATA LOCAL INFILE \'\". $infile .\"\' INTO TABLE default_comm_propTEMP_IDX\"

 

Any way, this command works great at the command line while logged in as root or the site admin.. But when I run it from php using web browser, it is trying to find the text file to load in the /var/www/html/admin directory of the SERVER and not within the site.. Of course it\'s not at the root server it\'s in the site directory\'s /var..

 

Does anyone know how to get it to refer to the /var/www/html of the site and not the server? This is taking forever...

 

Thanks!

Monica