Error 1 : Can't create/write to file

[Luca]

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
[url]http://dev.mysql.com/doc/refman/5.0...not-create.html[/url]

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

[Jerry Stuckle]

Luca wrote:

> 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
> [url]http://dev.mysql.com/doc/refman/5.0...not-create.html[/url]
>
> 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
>
>

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.
[email]jstucklex@attglobal.net[/email]
==================