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 <vegiv...@tuxera.be>: > ----- Original Message ----- >> From: "Rafał Radecki" <radecki.ra...@gmail.com> >> >> 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 tool, > 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 will > have been written in the same order - let alone that you won't have delete > 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql