Web lists-archives.com

Re: dump, drop database then merge/aggregate

----- Original Message -----
> From: "lejeczek" <peljasz@xxxxxxxxxxx>
> Subject: Re: dump, drop database then merge/aggregate
> today both databases are mirrored/identical
> tonight awkward end will dump then remove all the data, then
> collect some and again, dump then remove
> and these dumps should reconstruct the database on the other
> box.

It sounds like a horrible mess, to be honest. It's also pretty hard to recommend possible paths without knowing what's inside. Is it an option for you to simply import the distinct dumps into different schemas? That way there would be no need for merging the data, you just query the particular dataset you're interested in.

Unhappiness is discouraged and will be corrected with kitten pictures.

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql