List:General Discussion« Previous MessageNext Message »
From:David Ruggles Date:March 26 2007 7:27pm
Subject:RE: Select into outfile on nfs mount point
View as plain text  
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



Thread
Select into outfile on nfs mount pointDavid Ruggles26 Mar
  • RE: Select into outfile on nfs mount pointJerry Schwartz26 Mar
RE: Select into outfile on nfs mount pointDavid Ruggles26 Mar
RE: Select into outfile on nfs mount pointDavid Ruggles26 Mar
RE: Select into outfile on nfs mount pointDavid Ruggles26 Mar