Jump to content


Photo

LOAD DATA LOCAL INFILE


  • Please log in to reply
No replies to this topic

#1 monicaz

monicaz
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 29 December 2003 - 04:26 AM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users