On Tuesday 28 February 2006 23:41, Joshua Kugler wrote: > You can't do that. The mysql server runs as user mysql, so it cannot > create files owned by another user. If you run the mysql server as root > (don't!), you might be able to do that, but I do not believe mysql has a > facility for changing the owner of a file. You are better off running a > script as the user you want to own the file and outputing the results via > the script. > > j----- k-----
I was just going to post something similar to that. Try something like this: #!/bin/bash Your query you want to run....... chown user:user /path/to/report.cvs Then put this in your cron.daily or where ever you wish to run it or crontab 00 03 * * * /path/to/script I think I explained that right. :) -- 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]
