I'm really not able to resolve this.

I have a SELECT...INTO OUTFILE query

If I execute it I receive:
Error 1 : Can't create/write to file 'myfile.txt'

I've read
http://dev.mysql.com/doc/refman/5.0...not-create.html

and so :
1. I've modified " #tmp= /tmp " in " tmp=/tmp/mysql_tmp
2. I've give it permission (mysql)
3. I've modified php safe_mode to off

I still receive the same error. Why??

Luca

Luca wrote:
Did you take the # away from the front of the line? Otherwise it's a
comment.

Do YOU have write permission for /tmp/mysql_tmp?


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================