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