mysql root@localhost [(none)]> use wc_miehr_mhpc;
Database changed
mysql root@localhost [wc_miehr_mhpc]> check table patient_pdups;
+-----------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------+-------+----------+----------+
| wc_miehr_mhpc.patient_pdups | check | status | OK |
+-----------------------------+-------+----------+----------+
1 row in set (0.20 sec)
check table from slave that took snapshot:
mysql root@localhost [(none)]> use wc_miehr_mhpc; ------- ------- ------- --+---- ---+--- ------- +------ ----+ ------- ------- ------- --+---- ---+--- ------- +------ ----+ mhpc.patient_ pdups | check | status | OK | ------- ------- ------- --+---- ---+--- ------- +------ ----+
Database changed
mysql root@localhost [wc_miehr_mhpc]> check table patient_pdups;
+------
| Table | Op | Msg_type | Msg_text |
+------
| wc_miehr_
+------
1 row in set (0.20 sec)
See attache innodb backup.