Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. 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

By data integrity, I mean:

  • Schema integrity
  • Data (record level) integrity

Checksum was an option, but since the storage format for some data types in MySQL 5.5 has been changed, it won't be reliable.

Another option is to parse the XML file generated by mysqldump. Since the file is too large (in GBs), is it worth it?

Any other way you have confirmed it?

share|improve this question

You can use SQLyog-MySQL GUI (Trial) version to compare Schema as well as Data (records) to make sure consistency of schema and data as well.

Schema and Data Synchronization

Visual Data Compare

share|improve this answer
Data was huge(~100 GB) so I completely ruled out GUI tools. – bin Jul 27 '13 at 9:51
up vote 0 down vote accepted

I solved it by writing a script to get the data dump alone in .txt from both the mysql server machines and did a diff compare. I didn't find much differences except some DECIMAL values where mysql5.5 was clipping values(to the MAX value) in case the value exceeds the size defined for the column. The only problem was that it took some time.

You can check this link to find more details about the above issue here

share|improve this answer

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.