> I need to save my database (comma separated)in file which i can do by > mysql..admin command....now what i want to do is that this file gets > auto-emailed once a week to the concerned person....the site that uses mysql > is hosted on a linux machine.
> I can add a process that does the above in the cron of the linux environment > But i cant do that sinc the ISP that is hosting the site won't allow....can > anyone give me any clues? If you have shell access you could write a bash script with an infinite loop, that uses the 'sleep' command to wait 1 day between loops. something like : while (1) mysqldump --user=root mydatabase | mail [EMAIL PROTECTED] sleep 1d end Russ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php