If you use the 5.1 tree, you should be able to use the new EVENT stuff to accomplish this:
http://dev.mysql.com/doc/refman/5.1/en/events.html CREATE EVENT check_table ON SCHEDULE AT '2006-03-10 19:00:00' EVERY WEEK DO your_check_table_procedure_here(); Or something like that.. On 3/10/06, René Fournier <[EMAIL PROTECTED]> wrote: > Just curious, what cron jobs do you schedule for automatically > checking/repairing/analyzing/optimizing MyISAM tables? > > I have been doing this periodically, manually for a while, but I > figured cron is the way to go. > > Also, what parameters are you using? I am thinking of running the > following cron jobs: > > mysqlcheck --all-databases --auto-repair (daily) > mysqlcheck --all-databases --analyse (weekly) > mysqlcheck --all-databases --optimize (weekly) > > Good idea? Bad? Or just plain ugly? > > ...Rene > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
