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.
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.