|
Yes? So use a CRON job (on Linux) or SCHEDULED TASK (on Windows) to do this.
Note that you will want to shut down the DB while this happens. That is, disallow any connections to it other than by the ROOT user.
You will pardon me if I say that this seems to be a pretty pointless exercise. Why allow any changes, at all, to the database if you are going to reset it each day? Why not simply make all the data READ-ONLY? Then no changes can be made and you'll never need to reset it.
__________________
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
|