On Fri, Oct 25, 2013 at 10:53 AM, Andreas <maps(dot)on(at)gmx(dot)net> wrote:
> Hi,
>
> I'd like to set up a DB-Server that keeps copies of our productive db for an
> external db-assistant.
> He should prepare chores on the test-server and mail the sql scripts to me.
> I'll look over those scripts and run them against the productive db myself.
>
> So I'd like to have a daily cron job dump the main db, rename the test-db to
> something with a date in it.
> Like test_db --> test_db_20131024
> Create a new test_db and import the dump of the main db.
>
> So far no problem but how could I limit the number of test_dbs to 5?
> I'd like to keep those test_dbs 5 days and then drop them.
A simple script kicked by a cron job would do the work for you easily...
--
Michael