Hey, thanks *so* much for checking into this.
Your message did help. In case you're curious. First, I had the admin
create a 777 dump directory from root. Still couldn't write out. Then,
though, I just tried going to /tmp as you had done, and that was fine.
/tmp -- I feel like an idiot, but at least I'm an idiot who can dump the
database now:)
Also, do you happen to know how old is 3.23.21-beta-log? Our MYSQL is
old, but I can't find out how old, is there a version history online
anywhere?
-billb
-----Original Message-----
From: Diana Soares [mailto:dcsoares@stripped]
Sent: Tuesday, July 16, 2002 3:22 AM
To: Bill Bernat
Cc: mysql@stripped
Subject: Re: mysqldump question
On Tue, 2002-07-16 at 02:31, Bill Bernat wrote:
> Question: is there anything I need to be aware of when writing dump
> files to a local directory for my user, I'm having the following
> problem.
>
> 1. I create a directory in my own home directory (linux, red hat 7.2)
> ~/dumps and give it 777 permissions
>
> 2. I run " /usr/local/mysql/bin/mysqldump -uroot -p<<pass>> --tab
> ~/dumps dbname table1 table2"
>
> 3. The .sql file for table1 gets created, correctly, in the dumps
> directory fine.
>
> 4. mysqldump pukes when trying to write the .txt file:
>
> /usr/local/mysql/bin/mysqldump: Got error: 1: Can't create/write to
> file '/home/bbernat/dumps/customer_relations_database.txt' (Errcode:
> 13) when executing 'SELECT INTO OUTFILE'
>
> QUESTION:
> What have I done wrong and how can I fix it?
Hi,
I was curious about your problem and decided to try it.
As user root (in the filesystem, redhat7.2), i created the dir ~/dumps
with 777 permissions and have run
root@cartman:~# mysqldump -uroot -p --tab ~/dumps/ test
(root mysqluser has FILE permissions). It gave me the same error.
Then i tried with a common filesystem user (dsoares): dsoares@cartman:~$
mysqldump -uroot -p --tab ~/dumps/ test
And it worked!
I went to see my /root permissions and it was: dsoares@cartman:~$ ll -d
/root/
drwxr-x--- 31 root root 4096 Jul 16 11:09 /root/
So the problem was there! mysql user doesn't have permissions to access
/root directory. Maybe this is your problem.
(also as root i tried with /tmp/dumps directory, 777 permissions, and it
worked.)
--
Diana Soares
