List:General Discussion« Previous MessageNext Message »
From:Mike Spreitzer Date:February 23 2008 12:13am
Subject:Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) when
executing 'SELECT INTO OUTFILE'
View as plain text  
I am running MySQL 5.0.51a-community on RedHat Enterprise Linux 4.  Here 
is a further typescript showing the failure:

[root@xd026 /]# mysqldump -u root -p --skip-opt --quick --tab=/dump1 wyky 
red1_p2
Enter password: 
mysqldump: Got error: 1: Can't create/write to file '/dump1/red1_p2.txt' 
(Errcode: 13) when executing 'SELECT INTO OUTFILE'
[root@xd026 /]# ls -ld /dump1
drwxrwxrwx  2 mysql mysql 4096 Feb 22 19:11 /dump1
[root@xd026 /]# ls -l /dump1
total 16
-rw-r--r--  1 mysql mysql  29 Feb 22 18:38 foo.bar
-rw-r--r--  1 root  root  742 Feb 22 19:11 red1_p2.sql
[root@xd026 /]# 

Thanks,
Mike




Jed Reynolds <lists@stripped> 
02/22/08 07:04 PM
Please respond to
lists@stripped


To
Mike Spreitzer/Watson/IBM@IBMUS
cc
mysql list <mysql@stripped>
Subject
Re: mysqldump: Got error: 1: Can't create/write to file 
'dumpdir/tablename.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'






Mike Spreitzer wrote:
> So I am trying to use mysqldump --tab for the first time.  I am running 
> into the same problem everybody does on their first try --- Errcode: 13. 
I 
> have set the permissions on the target directory to be completely 
liberal 
> --- anybody can do anything with it --- and I still get Errcode: 13.  I 
> can even write into that directory when logged in as mysql (UID 100, GID 

> 100, and yes that is what the mysqld process is running as).  What's 
going 
> wrong here?
> 

SELinux enabled?

What's the syntax of the command you're using?

Jed


Thread
mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) whenexecuting 'SELECT INTO OUTFILE'Mike Spreitzer23 Feb
  • Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt'(Errcode: 13) when executing 'SELECT INTO OUTFILE'Jed Reynolds23 Feb
    • Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) whenexecuting 'SELECT INTO OUTFILE'Mike Spreitzer23 Feb
      • Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt'(Errcode: 13) when executing 'SELECT INTO OUTFILE'Jed Reynolds23 Feb
        • Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) whenexecuting 'SELECT INTO OUTFILE'Mike Spreitzer23 Feb
          • Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt'(Errcode: 13) when executing 'SELECT INTO OUTFILE'Jed Reynolds23 Feb