How to work around lack of 'Create Event' support for php/mysql?

software development

#1

Heya,

I have had great success with dreamhost PHP and MYSQL so far. However, I finally hit a snag. It does not allow CREATE EVENT or any type of Event Scheduler behavior.

How does everyone else work around this? Surely there must be some way to setup and run a scheduled database activity to clean up sessions, move out old records, etc… Out of the thousands of users, surely I cannot be the only one that wants to schedule a database cleanup activity.

Help!
Gigiwoo.


#2

cron.


#3

Beat me to it.

Hafta say I’d much rather use cron too; “CREATE EVENT” leaves way too much potential for a breach.