Koozali.org: home of the SME Server

phpmyadmin textfile upload

ted

phpmyadmin textfile upload
« on: November 12, 2003, 04:18:42 AM »
Yo,
I'm running e-smith 6.0b3. I use phpmyadmin 2.5.3-rc3 regularily and have been trying to use the "insert data from a textfile" but it tells me 'File could not be read /tmp/php6GHady' or some variation of /tmp/php...

I've set the upload_tmp_dir in php.ini to ".:/var/www/html/tmp" and set $cfg['UploadDir'] in phpmyadmin's config.inc.php to "/var/www/html/tmp"

thats pretty much all I can think of. I've tried using the mysql client locally with the "LOAD DATA LOCAL INFILE..." shtuff and it kind of worked. (it loaded the rows but there was some data missing).

any help?

Arno

Re: phpmyadmin textfile upload
« Reply #1 on: November 12, 2003, 09:43:48 PM »
Ur upload dir, all write read rights?
chmod 777 dir

ted

Re: phpmyadmin textfile upload
« Reply #2 on: November 13, 2003, 05:43:24 PM »
I made some progress. I changed the upload directory to /home/e-smith/files/ibays/data/html/tmp (data is phpmyadmin's ibay). Now I get a "can't get stat of..." error. There are lots of postings about this problem on the internet but no solution to be found. It is apparently a permissions problem but /home/e-smith/files/ibays/data/html/tmp has ownership data:shared and chmod 777. Do the upper level directories also need to have higher permissions?

ted

Re: phpmyadmin textfile upload
« Reply #3 on: November 13, 2003, 06:00:34 PM »
Well, for posterity, I figured it out. I gave the /home/e-smith/files/ibays/data/html chmod 711 and ownership data:shared

seemes to work!!
 woohoo!!