On Tuesday 28 February 2006 22:55, unplug wrote: > Hi, > When I use a query "SELECT * into outfile '/tmp/report.csv' fields > terminated by ',' lines terminated by '\n' FROM table;", it will > create a file with the following permission and owner. > > -rw-rw-rw- 1 mysql mysql 2489 Mar 1 11:30 report.csv > > How can I change the default permission or the ownership of the file? > > Rgds, > unplug
chown your_username:your_username report.cvs Of course change the "your_username" to the user you are logged in as. -- Best regards, ~WILL~ Key: http://code-heads.com/keys/ch1.asc Key: http://code-heads.com/keys/ch2.asc Linux Commands: http://code-heads.com/commands Linux Registered User: 406084 (http://counter.li.org/) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
