ahhh.. ok, I understand.. So the moral of the story is the mysql process
itself touches the local filesystem. It's NOT the UID of the person running
the command that matters, it's who the daemon is running as.
Hence the reason the help page says "this only works when running on the
same machine the daemon is on."
But, I imagine the first part of the export IS running as root, because it
works.
Thank you for clearing this up, that didn't make a whole lot of sense to me,
not it makes perfect sense.
The export works now, case closed.. Thanks again!
Joel
----- Original Message -----
From: "Quentin Bennett" <[EMAIL PROTECTED]>
To: "'Joel Caturia'" <[EMAIL PROTECTED]>; "Gerald L. Clark"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 2:19 PM
Subject: RE: mysqldump Error
> Hi,
>
> But is your mysql server run by root, or, as advised, by 'mysql'?
>
> Quentin
>
> -----Original Message-----
> From: Joel Caturia [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 15 March 2001 10:56 a.m.
> To: Gerald L. Clark
> Cc: [EMAIL PROTECTED]
> Subject: Re: mysqldump Error
>
>
> ah but I do.. Allow me to prove it..
>
> drwxr-xr-x 4 root wheel 512 Mar 14 12:50 work
>
> [root@fugu work]# touch this_works
> [root@fugu work]# ls -la
> -rw-r--r-- 1 root wheel 0 Mar 14 13:42 this_works
>
> And, as I stated before, the Calls.sql file IS being created in this same
> directory.
>
> Is it possible this sort of permission denied is related to some part of
the
> database?? I should mention that I can run a "normal" mysqldump till I'm
> blue in the face, it's just when I try and create these tab deliminated
> files that is chokes.
>
> Thanks!
>
> Joel
> ----- Original Message -----
> From: "Gerald L. Clark" <[EMAIL PROTECTED]>
> To: "Joel Caturia" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 14, 2001 1:43 PM
> Subject: Re: mysqldump Error
>
>
> > Joel Caturia wrote:
> > >
> > > I'm trying to use mysqldump to dump a database (obviously).
> > >
> > > Here's the commandline I'm using:
> > > [root@fugu work]# mysqldump --tab=. wonderdesk
> > >
> > > mysqldump: Got error: 1: Can't create/write to file
> '/root/work/Calls.txt' (Errcode: 13)
> > >
> > > The interesting thing, is that is IS creating Calls.sql, but it then
> crashes on Calls.txt.
> > >
> > > I've got plenty of drive space, file permissions aren't a problem, and
> it's creating some files, but not all of them. Anyone got any Ideas?
> > >
> > > I've searched around a bit, and haven't been able to find what an
> errcode 13 is, so I'm out of ideas.
> > >
> > > Thanks guys!
> > >
> > > Joel
> > perror 13
> > Permission denied
> >
> > You don't have write permission in /root/work.
> >
> >
>
>
>
> ---------------------------------------------------------------------
> 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
>
> The information contained in this email is privileged and confidential
> and intended for the addressee only. If you are not the intended
> recipient, you are asked to respect that confidentiality and not
> disclose, copy or make use of its contents. If received in error
> you are asked to destroy this email and contact the sender immediately.
> Your assistance is appreciated.
>
---------------------------------------------------------------------
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
