Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.