I have had that situation before and the answer was in the permissions that
were issued in the nfs mount statement..
Try this from machine a to machine b.. try to edit a file with a editor and
save it on the other machine.. if it doesnt allow you to save, that would be
the first clue..
Robert Saunders
robert@stripped
----- Original Message -----
From: Ronald Beck <ronald-beck@stripped>
To: Roger Smith <roger@stripped>
Cc: mysql-help <mysql@stripped>
Sent: Tuesday, July 13, 1999 3:56 PM
Subject: Re: Exporting
>
> Are you sure that the userid that's running mySQL can write to the
> directory? I use NFS mounts for any and all directory connections
> without a problem. Try creating a file in the directory you're trying
> to write to and see if you get an error.
>
> Ron
>
> Roger Smith wrote:
> >
> > Hey guys I have mysql running on one machine, and out web server is
> > running on another machine, and these two machines are NFS mounted,
> > so I am doing "select * from users into outfile "filename";
> >
> > where for filename I give it the directory that is mounted, and it won't
> > write the file, it says error 2000: Can't create/write to file
"filepath"
> >
> > but if I just try to save the fiel to somewhere on the local machine it
> > works great!!!!!!!!!!
> > Anyone know why it won't work over NFS mounts?
> > Thanks
> >
> > Roger R. Smith
> > roger@stripped
> > MetaLab. I love it and so can you!
> > (919) 962-5646
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread7198@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
