Hi guys,

From MySQL document, any files created by INTO OUTFILE is writable by all users, but I only get the 660 permission when using above command:

Therefore, I got following error when loading file back:

The file ‘test.out’ must be in the database directory or be readable by all

The permission of directory contains output file:

Even when I created it in database directory, I got the another error:

Only when executing chmod o+r, I can LOAD DATA INFILE successful.

Any help will be appreciated.

PS: LOAD DATA LOCAL INFILE works fine on my server itself.

Hi,

All files read/written by SELECT ... INTO OUTFILE and LOAD… DATA INFILE are processed by the mysqld process, and inherit the userid and permissions and umask of the user running mysqld (normally “mysql”).

If you want to change the file mode on the files created by SELECT ... INTO OUTFILE, simply change the umask in the user profile of the user “mysql”. This can be done by putting the command:

in the .bashrc (or .bash_profile) of the user “mysql”‘s home directory.

Geoffrey

I can’t get this to work.
I am running IEE 3.5.2 on rhel-5.

I am trying to get a file with 664 permissions. I have tried the following:

1. set umask 0002 in $HOME/.bashrc
2. export UMASK=0664 in $HOME/.bashrc

Neither of those worked. Before each test I would:
1. Make the change to the .bashrc
2. Log off the mysql user and log back in
3. Run /etc/init.d/mysqld-ib restart
4. Delete the file I was trying to write
5. Run the SELECT INTO OUTFILE

The only that did “work” was when I put export UMASK=0644 in $HOME/.bashrc. This resulted in a file with 640 permissions. Infobright seems unable/unwilling to set the world permissions to anything other than 0.