Sorry if I have confused people by presenting evidence in the wrong order. Also, it seems that the .sql file is written by the client while the .txt file is (attempted to be) written by the server. Here is a single typescript with all the evidence:
[EMAIL PROTECTED] ~]# cd / [EMAIL PROTECTED] /]# rm -f dump1/* [EMAIL PROTECTED] /]# ls -ld dump1 drwxrwxrwx 2 mysql mysql 4096 Feb 22 20:45 dump1 [EMAIL PROTECTED] /]# ls -l dump1 total 0 [EMAIL PROTECTED] /]# 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' [EMAIL PROTECTED] /]# ls -l dump1 total 8 -rw-r--r-- 1 root root 742 Feb 22 20:46 red1_p2.sql [EMAIL PROTECTED] /]# ps axlw | grep mysqld 0 0 8494 1 25 0 3408 944 wait S pts/5 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/xd026.watson.ibm.com.pid 4 100 8517 8494 16 0 251828 154772 - Sl ? 4:05 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/xd026.watson.ibm.com.pid --skip-external-locking 0 0 26228 26177 16 0 4704 672 pipe_w S+ pts/1 0:00 grep mysqld [EMAIL PROTECTED] /]# su - mysql -bash-3.00$ id uid=100(mysql) gid=101(mysql) groups=101(mysql) context=user_u:system_r:unconfined_t -bash-3.00$ cd /dump1 -bash-3.00$ date > foo.bar -bash-3.00$ ls -l total 16 -rw-r--r-- 1 mysql mysql 29 Feb 22 20:46 foo.bar -rw-r--r-- 1 root root 742 Feb 22 20:46 red1_p2.sql -bash-3.00$ Thanks, Mike Jed Reynolds <[EMAIL PROTECTED]> 02/22/08 07:24 PM Please respond to [EMAIL PROTECTED] To Mike Spreitzer/Watson/[EMAIL PROTECTED] cc mysql list <mysql@lists.mysql.com> Subject Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE' what happens when you delete the files that are already in there? Looks like you're dumping to a file owned by root. Jed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
