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 wheel0 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
