From: Johan De Meersman Date: February 19 2013 12:05pm Subject: Re: How to verify if backup is ok? List-Archive: http://lists.mysql.com/mysql/229009 Message-Id: <19729929.6026.1361275535463.JavaMail.root@tuxera.be> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable ----- Original Message ----- > From: "Rafa=C5=82 Radecki" >=20 > 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 ol= der 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 := -( --=20 Unhappiness is discouraged and will be corrected with kitten pictures.