thanks amanda... the "local" worked for some reason...
in about 10 years of using mysql i have never had to do that.
i still wonder why would the thing not stat it.
file and dir are both 777 and owned by mysql...
one thing i noticed thou is that the actual user is not mysql but
_mysql. that's how is stored in passwd and that's how it's represented
by ls -al.
the process thou was started with --user=mysql...
but i still don't get the necessity of "local". i have never used it before.
this is all on os x - 10.8.2...
On 10/17/12 1:25 PM, Ananda Kumar wrote:
> also try using "load data local infile 'file path' and see if it works
>
> On Wed, Oct 17, 2012 at 10:52 PM, Ananda Kumar <anandkl@stripped
> <mailto:anandkl@stripped>> wrote:
>
> does both directory have permission "777"
>
>
> On Wed, Oct 17, 2012 at 9:27 PM, Rick James <rjames@stripped
> <mailto:rjames@stripped>> wrote:
>
> SELinux ?
>
> > -----Original Message-----
> > From: Lixun Peng [mailto:penglixun@stripped
> <mailto:penglixun@stripped>]
> > Sent: Tuesday, October 16, 2012 9:03 PM
> > To: kalin
> > Cc: Michael Dykman; mysql@stripped
> <mailto:mysql@stripped>
> > Subject: Re: error 13
> >
> > Hi,
> >
> > you can switch to mysql user "su - mysql", and then stat this
> file.
> > if you can't access, mysql user have not permissions.
> >
> > On Wed, Oct 17, 2012 at 11:49 AM, kalin <kalin@stripped
> <mailto:kalin@stripped>> wrote:
> >
> > >
> > >
> > >
> > > On 10/16/12 10:49 PM, Michael Dykman wrote:
> > >
> > >> is your mysql client on the same host as the mysql server?
> if not,
> > >> google the docs for 'local infile'
> > >>
> > >
> > > yes. my laptop.
> > >
> > >
> > >
> > >
> > >
> > >> On 2012-10-16 10:45 PM, "Lixun Peng" <penglixun@stripped
> <mailto:penglixun@stripped>> wrote:
> > >>
> > >> Hi,
> > >>
> > >> What's the dir permissions?
> > >>
> > >> For example, if we have a file in /a/b/file, dir a is 644,
> even
> > >> though file is 777, we can't access file, too.
> > >>
> > >>
> > >> On Wed, Oct 17, 2012 at 10:31 AM, kalin <kalin@stripped
> <mailto:kalin@stripped>> wrote:
> > >>
> > >>
> > >>>
> > >>> hi all..
> > >>>
> > >>> this hasn't happe...
> > >>>
> > >> --
> > >> Senior MySQL Developer @ Taobao.com
> > >>
> > >> Mobile Phone: +86 18658156856 (Hangzhou)
> > >> Gtalk: penglixun(at)gmail.com <http://gmail.com>
> > >> Twitter: http://www.twitter.com/plinux
> > >> Blog: http://www.penglixun.com
> > >>
> > >>
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe: http://lists.mysql.com/mysql
> > >
> > >
> >
> >
> > --
> > Senior MySQL Developer @ Taobao.com
> >
> > Mobile Phone: +86 18658156856 (Hangzhou)
> > Gtalk: penglixun(at)gmail.com <http://gmail.com>
> > Twitter: http://www.twitter.com/plinux
> > Blog: http://www.penglixun.com
>
>
>