Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What's the best way to compare two database? assuming I have same schema, and by compare, I mean I need to know if data value's are the same. I need to do that within MySQL.

share|improve this question

if you want just to compare - use mk-table-checksum from maatkit.

you'll find there also other tools - eg. mk-table-sync that you can use to sync back one server to another in an efficient way.

share|improve this answer
my tables are mix between MyISAM and InnoDB – alexus Feb 4 '10 at 21:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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