At 5:18 -0500 6/2/04, [EMAIL PROTECTED] wrote:
There's got ot be something else wrong. I've got the exact same problem and
I have done a chmod 666 on the directory I am trying to write to with no
luck. I am running v4.0.15
Mode is not enough, you must consider ownership.
Remember, *you* are not trying to write the file. The MySQL server
(mysqld) is trying to write the file, and it might not be running
under your user ID. It's probably running from the "mysql" account.
/T
on 6/1/04 7:06, Egor Egorov at [EMAIL PROTECTED] wrote:
John Mistler <[EMAIL PROTECTED]> wrote:
Would there be any obvious reasons for its inability to access the desktop?
I have used that desktop directory many times before in UNIX.
Check permissions on that dir. It must be writeable by the user
you run mysqld
as ('mysql' by default).
on 6/1/04 12:49 AM, Egor Egorov at [EMAIL PROTECTED] wrote:
John Mistler <[EMAIL PROTECTED]> wrote:
Can anyone guess why I am getting this error:
"ERROR 1: Can't create/write to file
'/Users/johnmistler/Desktop/TestFile.txt' (ERRCODE 13)"
when using this statement:
mysql> SELECT * INTO OUTFILE
'/Users/johnmistler/Desktop/TestFile.txt' FROM
theTable WHERE column1 != 'thisString';
? I am logging in as root for the test.
It means that MySQL server can not access to the
/Users/johnmistler/Desktop/
directory.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
