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 mysqld<http://dev.mysql.com/doc/refman/5.1/en/mysqld.html>as 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?