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 <[email protected]>:
> ----- Original Message -----
>> From: "Rafał Radecki" <[email protected]>
>>
>> 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
