I got a little challenge here and hope that maybe someone has a good answer.
I have several domains, all of them run a CMS that utilizes its own MYSQL DB. In each database there is a table that accumulates lots of temporary data. This data is used weekly and could be deleted thereafter. However, it does not remove the data so that this particular table grows huge in each of the databases.
So, I look for a way to empty the database automatically on a set schedule. Or even better delete all data that are older then 7 or 10 days on a daily basis.
Is there some command that can do this across many databases. Or at least on one database?