Yes I can touch the file with the mysql user. The only thing I can't do is a
select into file. However select into file works anywhere else on the
filesystem.
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Network Engineer Safe Data, Inc.
(910) 285-7200 david@stripped
-----Original Message-----
From: Jerry Schwartz [mailto:jschwartz@stripped]
Sent: Monday, March 26, 2007 12:06 PM
To: 'David Ruggles'; mysql@stripped
Subject: RE: Select into outfile on nfs mount point
Can you "touch" the file name? It might be a permission issue at the
directory level, it has to be writeable.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -----Original Message-----
> From: David Ruggles [mailto:david@stripped]
> Sent: Monday, March 26, 2007 11:51 AM
> To: mysql@stripped
> Subject: Select into outfile on nfs mount point
>
> I'm unable to select into an outfile, the path is in an nfs
> mount point. I'm
> sure it's some sort of permissions issue or something, but I
> can't figure it
> out. I've googled everything I can think of and haven't found
> anything. Any
> help or suggestions would be greatly appreciated.
>
> The error I'm getting is:
> Error Code : 1
> Can't create/write to file './sqldata/test.txt' (Errcode: 524)
>
> I see from the mysql site that Error Code 1 = Operation not permitted
>
> The sqldata is an nfs mount to another server with full read/write
> permissions. I can read and write without problem from the
> commandline as
> the mysql user.
>
> Thanks,
>
> David Ruggles
> CCNA MCSE (NT) CNA A+
> Network Engineer Safe Data, Inc.
> (910) 285-7200 david@stripped
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
