Verifying Restoration

After restoration, ZRM for MySQL shuts down the MySQL server. It is important to check the database(s)/table(s) that were restored.

SQL command CHECK TABLE can be used for consistency checking. Use of EXTENDED option is recommended. EXTENDED option does a full key lookup for all rows in the table and will take significant time for a large database.

mysql> CHECK TABLE <table1>, <table2> EXTENDED;

No other application must be using the database during table consistency check.