MySQL Forums
Forum List  »  MyISAM

Checksum differences
Posted by: Anthony Ferrara
Date: May 17, 2007 03:02PM

I've got 2 database servers running the same database (cannot do replication as one is live and the other development). One of the databases needs to be synced from time to time. Because it's rather large, I'm looking to only transfer tables that have changed, and hence am using the CHECKSUM TABLE command to determine if tables have identical data. Dev server is MySQL 5.0.24a Live is MySQL 5.0.18

The problem, is that a few of our tables NEVER report identical checksums. I have verified that they are identical (by exporting from one server, importing to the other as a different name, and doing a checksum on that server). Any ideas as to what I can do? Schema's are Identical. I've ran optimize and repair table, to no effect. Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Checksum differences
2821
May 17, 2007 03:02PM
1886
July 19, 2007 03:59PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.