the path from php to www ?

Anon

Hi, Im trying to use select into outfile to write my mysql content into a text file but it says I havent got the right permissons.

So I guessed this was because its trying to create a file in the actual mysql directory where I dont have any permissions.

My question is : how can i find out what the location of my www dir is so i can select into outfile to that exact location.

Its a linux webserver.

tia

plamendp

Just create a directory, give it a 777 (world writable)permissions. Now "nobody" (the http uid) can write there.

SELECT INTO OUTFILE '/path/to/your/outfile.csv' ....

"your" must have 777 perms.
"outfile.csv" must NOT exists.
unlink() it before.

You are trying "select into outfile .." from within PHP script, right ?

regards

Anon

hmz no,
I was trying that from a telnetted mysql session.

but the problem is that i dont know the " /path/to/my/root/ "

if I exec it from a php script then the path would probably be the same as the sript right ?

plamendp

SELECT *
FROM yourtable
INTO OUTFILE
'/absolute/path/to/your/outfile.csv'
FIELDS TERMINATED BY '\t';

should work.

If no absolute path is given, mysql tryies to write to the default db directory. Here permissions are the problem.

Well, you must know /path/to/my/root/ . Nothing would help if don't know your home :-)

regards,

Anon

Watch it ! This could be a configuration problem (I understand the php version you use is not 100% compatible with the Mysql version). I´ve had the same problem with my hosting provider.

ciao.