How to run a query hourly...

[TalkHardRandy]

I have one of the phpMyChat Intergration hacks on the board, which I got working & is muy cool...

Except that I need it to clear the messages quicker than the minimum which is 1 hour. Something more like 15 mins or so. I know this is DB intensive, but my provider tells me that it can handle it.

I can do this in the phpMyAdmin by doing a DELETE FROM table, but I have to do it manually. I've poked around to find a hack that will automate this and the best I've found is being able to run queries from the Admin CP.

Any ideas?

[fox_m]

well if it is an linux/unix box the host is running and you have shell access you can slap it into cron by typing the command
crontab -e
and then
/usr/local/mysql/bin/mysql -h <hostname or ip> -u <username> --password=<password> <full path to sql file>

That way you only have to create one file with the sql in it.

if the host is running an windows box then i have no idea....

Fox_m