2

Running mysqldbcompare on two test databases on same server. There is no data discrepancy in any table but showing following message which I'm not able to understand. Any help is appreciated.

TABLE         a                                     pass    pass    -       
            - Compare table checksum                                FAIL    
            - Find row differences                                  pass     

TABLE         b                                      pass    pass    -       
            - Compare table checksum                                FAIL    
            - Find row differences                                  pass  
3

It means that the simple approach (table checksum) failed, but that the rows are identical, which is a pass. Since the row checksum takes a lot longer than the table checksum, you want to have table checksums pass as much as possible to avoid subsequent row checksums.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.