Thanks, I will use this tool :)
2013/2/19 Johan De Meersman <vegivamp@stripped>:
> ----- Original Message -----
>> From: "Rafał Radecki" <radecki.rafal@stripped>
>>
>> pt-table-checksum performs an online replication consistency check by
>> executing checksum queries on the master, which produces
>> different results on replicas that are inconsistent with the
>> master. -> It should be used for verifing mysql replication, not for
>> my problem.
>
> Hmm, I didn't realise that that was not a part of pt-table-checksum. The older
> mk-table-checksum from Maatkit doesn't particularly care about masters and slaves, and
> will happily compare to unrelated databases. You can still find it at
> http://www.maatkit.org/doc/mk-table-checksum.html#description .
>
> I just copied the contents of a db to another db on the same server, and it works as
> advertised.
>
> Not the first feature that I noticed hasn't been merged into the PT suite :-(
>
>
> --
> Unhappiness is discouraged and will be corrected with kitten pictures.