Yes, but wouldn't it be the user that the mysql service is running as? That is the user I am logging in as to test this.
Thanks, David Ruggles CCNA MCSE (NT) CNA A+ Network Engineer Safe Data, Inc. (910) 285-7200 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 26, 2007 12:01 PM To: David Ruggles Subject: Re: Select into outfile on nfs mount point the file on the mount point has to be able to be created, and read/write by the user that is invoking the mysql call. e.g., if this is begin done at the commandline - then it's the logged-in user (not the user "-u <user>" on the mysql command). if via a script, then by whatever user is calling the script (e.g., if via cron, what user is the crontab under). if it's through a web server, then it's the user that the web server is running as. - Rick ------------ Original Message ------------ > Date: Monday, March 26, 2007 11:50:59 AM -0400 > From: David Ruggles <[EMAIL PROTECTED]> > To: mysql@lists.mysql.com > 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. ---------- End Original Message ---------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
