Re: Permissions and Into Outfile

--000e0cd2de9c4d49c3048af02164
Content-Type: text/plain; charset=UTF-8

Hi all,

From the manual:

*Any file created by INTO OUTFILE or INTO DUMPFILE is writable by all users
on the server host. The reason for this is that the MySQL server cannot
create a file that is owned by anyone other than the user under whose
account it is running. (You should never run
mysqldas
root for this and other reasons.) The file thus must be world-writable so
that you can manipulate its contents.
*
but the output file has only permission is 660:

*-rw-rw---- 1 mysql mysql 3387 Jul 9 12:14 1022_clickAll.out
-rw-rw---- 1 mysql mysql 0 Jul 9 13:51 1022xxx_clickAll.out
-rw-rw---- 1 mysql mysql 13789 Jul 8 18:22 103_click.out
-rw-rw---- 1 mysql mysql 5150 Jul 8 18:22 104_click.out
-rw-rw---- 1 mysql mysql 7458 Jul 8 18:22 105_click.out
-rw-rw---- 1 mysql mysql 432193215 Jul 9 00:57 2010-07-08_.out
-rw-rw---- 1 mysql mysql 1955472228 Jul 9 00:51 2010-07-08.out
*
therefore, client (EMS MySQL Manager) got following error:

*The file '/vnfs/share129/mysqldata/102_viewAll.out' must be in the database
directory or be readable by all*

mysql user has writable permission to current directory:

*# ls -ld .
drwxr-xr-x 2 mysql mysql 4096 Jul 9 15:11 .
*
How can I make the output file readable by all?

--000e0cd2de9c4d49c3048af02164--