Resources:
Http://blog.chinaunix.net/uid-405749-id-28215.html
Http://www.cnblogs.com/xiaoit/p/3990304.html
Http://www.jb51.net/article/25873.htm
The process of recovering a damaged table on an online operation:
mysql> Check table tbl_referer05;
+-----------------------------+-------+----------+-----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------+-------+----------+-----------------------------------------------------------+
| drnew_monitor.tbl_referer05 | Check | Warning | Table is marked as crashed and last repair failed |
| drnew_monitor.tbl_referer05 | Check | Warning | Clients is using or haven ' t closed the table properly |
| drnew_monitor.tbl_referer05 | Check | Warning | Size of datafile is:672742692 should be:672710844 |
| drnew_monitor.tbl_referer05 | Check | Error | Found Keys of 1998767 |
| drnew_monitor.tbl_referer05 | Check | Error | corrupt |
+-----------------------------+-------+----------+-----------------------------------------------------------+
5 rows in Set (0.00 sec)
mysql> repair table tbl_referer05;;
+-----------------------------+--------+----------+---------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------+--------+----------+---------------------------------------------------------+
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 152960; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 184660; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Wrong bytesec:101-98-75 at 488558800; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 965508; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 985580; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 989772; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Wrong bytesec:116-116-112 at 488561736; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 2422076; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 2876164; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Wrong bytesec:51-48-49 at 488606848; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 3184428; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Wrong bytesec:105-46-99 at 488626364; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Wrong bytesec:52-51-46 at 488626384; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 3910968; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Wrong bytesec:37-50-50 at 488642480; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Wrong bytesec:50-50-54 at 488642504; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 4270476; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 4278508; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 4812248; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Wrong bytesec:59-32-122 at 488696156; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 5240200; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 5272204; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Wrong bytesec:15-0-at 488710432; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 5840716; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 5864136; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 5887872; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Delete link points outside datafile at 488724136 |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 6467604; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Wrong bytesec:53-46-55 at 488748676; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 6736884; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 6744696; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 6949524; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 6993404; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 7012028; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Wrong bytesec:116-112-58 at 488789212; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 7475056; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 7636404; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 7725468; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 7744088; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Wrong bytesec:24-0-133 at 488825908; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 8226208; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 8286068; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Wrong bytesec:53-54-47 at 488843692; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Wrong bytesec:59-32-119 at 488857180; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 8646640; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Wrong bytesec:101-114-47 at 488868524; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 8909900; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 8975320; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 8995780; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 583596204; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 594127704; Skipped |
| drnew_monitor.tbl_referer05 | Repair | info | Found block with too small length at 594215860; Skipped |
| drnew_monitor.tbl_referer05 | Repair | Warning | Number of rows changed from 1998767 to 1951358 |
| drnew_monitor.tbl_referer05 | Repair | Status | OK |
+-----------------------------+--------+----------+---------------------------------------------------------+
163 rows in Set (26.67 sec)
mysql> Check table tbl_referer05;
+-----------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------+-------+----------+----------+
| drnew_monitor.tbl_referer05 | Check | Status | OK |
+-----------------------------+-------+----------+----------+
1 row in Set (5.16 sec)
mysql> Repair table tbl_referer05;
+-----------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------+--------+----------+----------+
| drnew_monitor.tbl_referer05 | Repair | Status | OK |
+-----------------------------+--------+----------+----------+
1 row in Set (26.54 sec)
mysql> repair table tbl_referer06;;
+-----------------------------+--------+----------+-----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------+--------+----------+-----------------------------------------------------------+
| drnew_monitor.tbl_referer06 | Repair | info | Wrong block with wrong total length starting at 414722584 |
| drnew_monitor.tbl_referer06 | Repair | Warning | Number of rows changed from 1440927 to 1440926 |
| drnew_monitor.tbl_referer06 | Repair | Status | OK |
+-----------------------------+--------+----------+-----------------------------------------------------------+
3 Rows in Set (26.94 sec)
This article is from the "10931853" blog, please be sure to keep this source http://wujianwei.blog.51cto.com/10931853/1959436
MySQL Repair corrupted table considerations