Table of contents
No headersAfter 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.