Daniel Kasak wrote:
Actually thinking about this more, you can probably skip this bit and just direct your output from the command called by cron, as per Spenser's example.Write your script with the following line at the top:
tee /path/to/output/file.sql
ie:
mysql -u username -ppassword < /path/to/my_nightly_sql_commands.sql > /path/to/output_file.sql
It seems a bit cleaner...
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
