Dan Nelson schrieb:
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
Okay. I guess I'll have to stick with cronjobs then!

Thanks,
Samy

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to