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
