List:General Discussion« Previous MessageNext Message »
From:kalin Date:October 17 2012 7:49pm
Subject:Re: error 13
View as plain text  
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
>
>
>
Thread
error 13kalin17 Oct
  • Re: error 13Lixun Peng17 Oct
    • Re: error 13Michael Dykman17 Oct
      • Re: error 13kalin17 Oct
        • Re: error 13Lixun Peng17 Oct
          • RE: error 13Rick James17 Oct
            • Re: error 13Ananda Kumar17 Oct
              • Re: error 13Ananda Kumar17 Oct
                • Re: error 13kalin17 Oct
                  • Re: error 13Ananda Kumar18 Oct
                    • Re: error 13kalin18 Oct
                      • Re: error 13Michael Dykman18 Oct
                      • Re: error 13Ananda Kumar19 Oct
    • Re: error 13kalin17 Oct