Jump to content

Archived

This topic is now archived and is closed to further replies.

monicaz

LOAD DATA LOCAL INFILE

Recommended Posts

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.