How can we check for data integrity when we upgrade from MySQL 4.1 to MySQL 5.5? 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?
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.