From: Dan Nelson
Date: May 22 2008 6:39pm
Subject: Re: Triggering an action every 24 hours
List-Archive: http://lists.mysql.com/mysql/212962
Message-Id: <20080522183917.GB3192@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (May 22), Samuel Vogel said:
> Hey,
> 
> I am wondering how I can trigger an Action every 24 hours inside of mysql.
> A cron job would also do the job, but it won't work on shared hosts and 
> it's just another point of failure.
> 
> So is there any way to run a specific SQL command every 24 hours inside of 
> mysql?
> I'm using MySQL 5.0.51!

MySQL 5.1 added an event scheduler that would do what you need, but
there's nothing built into 5.0.  You'll have to make do with cron jobs,
or check out upgrading to 5.1.

http://dev.mysql.com/doc/refman/5.1/en/events.html

-- 
	Dan Nelson
	dnelson@stripped