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?