On Tue, 2002-07-23 at 21:04, Bill Bernat wrote: > 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?
Check this: http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.23.x It shows some release dates. > -----Original Message----- > From: Diana Soares [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 3:22 AM > To: Bill Bernat > Cc: [EMAIL PROTECTED] > 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 --------------------------------------------------------------------- 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