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