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 <vegivamp@stripped>:
> ----- Original Message -----
>> From: "Rafał Radecki" <radecki.rafal@stripped>
>>
>> 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.
