Merging 2 databases

[ade234uk]

We run quite a small auction site. I take a back up of MySQL everyday.
The software is set up so that closed auctions will be deleted after (x) amount of days and this includes any information relating to that auction. This is done to free up space.

The problems with this is that later I may want to do some reporting, so I wont have all the info to hand as some of these auctions may have been deleted.

So what I was thinking is there a way to merge two mysql databases togther later on?

[_uk_stuff]

A way you could achieve this would be to perform a mysqldump of the older table... This will give you a number of insert statements for each of the records in the database.

You could then replay these as and when you require access to them?

Its a bit of a fudge, but a workable solution.

Failing this you could try to use the MySQL GUI tools. I believe that the mysql migration client lets you combine the content of two identical table structured databases into a single one.