From: Rafał Radecki Date: February 19 2013 12:14pm Subject: Re: How to verify if backup is ok? List-Archive: http://lists.mysql.com/mysql/229010 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: quoted-printable Thanks, I will use this tool :) 2013/2/19 Johan De Meersman : > ----- Original Message ----- >> From: "Rafa=B3 Radecki" >> >> 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 master= s and slaves, and will happily compare to unrelated databases. You can stil= l 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.