mysql修复表
时间：2021-07-01 10:21:17
帮助过：16人阅读
log_check_user;
ERROR 1194 (HY000): Table
‘log_check_user‘ is marked as crashed and should be repaired
mysql>
repair table log_check_user;
+----------------------+--------+----------+-------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------+--------+----------+-------------------------------------------------+
| sg456.log_check_user | repair | info | Wrong bytesec: 0- 0- 0 at 68974624; Skipped |
| sg456.log_check_user | repair | warning | Number of rows changed
from 428999 to 428998 |
| sg456.log_check_user | repair | status | OK |
+----------------------+--------+----------+-------------------------------------------------+
3 rows
in set (24.87
sec)
mysql> select *
from log_check_user;
mysql修复表
标签：ble pair 原因 back 方法 air user log 数据库
