Validate database backup For Innodb tables Every fortnight, I take MySQL database dump from slave and then perform following steps as backup validation.


Number of Tables in every database.
Validate Schema of tables.
Validate random records for important tables.
An approximate(as its a backup) count of records in the table (only for MyISAM)


I am able to complete the activity. However since most of the tables are in InnoDB, I am not able to validate count properly. What solution can be there as count(*) is too slow in innodb?
Would this work for you?

SELECT database_name, table_name, last_update, n_rows
FROM mysql.innodb_table_stats;

immediately after DR?  To allow verification and avoid the long COUNT(*).