From: Rafał Radecki Date: February 19 2013 11:28am Subject: Re: How to verify if backup is ok? List-Archive: http://lists.mysql.com/mysql/229008 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: quoted-printable Thanks for the reply. 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. Any other tips? Best regards, Rafal Radecki. 2013/2/18 Johan De Meersman : > ----- Original Message ----- >> From: "Rafa=B3 Radecki" >> >> 3) drop mysql and app databases; >> 4) restore them from backup; > > Instead of dropping the DBs, simply restore to another database or server= . That will also allow you to perform a comparison using some graphical too= l, or if that fails mysqldumps and diff. > >> tips? Should I do it on filesystem level or on mysql level? Are there >> any external tools? > > Filesystem level won't work, as it's fairly unlikely that the records wil= l have been written in the same order - let alone that you won't have delet= e gaps etc. > > Percona toolkit has tools to verify master/slave setups (pt-table-compare= , I believe), I suppose they would also work on non-replicated setups. > > > -- > Unhappiness is discouraged and will be corrected with kitten pictures.