Hey BJ, Can the mysql user actually get into that directory ('/home/user/directory')?
If the mysql user can't read that directory, then it doesn't matter than it owns that file. You might want to check, do an 'su - mysql' ( replace mysql with whatever user is running the mysql daemon ), then try an do an 'ls -l' on both files. Hope this helps. -- sh On Fri, 2002-04-12 at 15:11, Jim Dickenson wrote: > Did you try load data local? That way, as I understand things, the server is > not reading the data the client is. > > > > On 4/12/2002 1:26 PM, "BJ Phillips" <[EMAIL PROTECTED]> wrote: > > > I can load files from '/home/mysql' but when trying to do it from any other > > user ('/home/user/directory'), I get an error 13 about cannot get stat on > > file such and such. The files are located on the server and are owned by > > the user, both mysql user and the system user. > > I specify the full path to the files, but still no good. Like I said, the > > only difference is the location of the files..../home/mysql versus > > /home/user. > > What is the deal? > > > > Thanks for you time, > > > > -=BJ=- > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > -- > Jim Dickenson > mailto:[EMAIL PROTECTED] > > Computers for Marketing Corporation > http://www.cfmc.com/ > > eFax: 1-419-791-8924 > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php