首页 > 数据库技术 > 详细

mysql修复表

时间:2018-01-03 18:22:34      阅读:225      评论:0      收藏:0      [点我收藏+]

数据库Table xxx is marked as crashed and should be repaired错误的解决方法服务器断电等原因可能导致数据表损坏,导致访问的时候提示:Table xxx is marked as crashed and should be repaired其中xxx为表的名称。

找到对应的表,使用 repair table table_name; 进行修复

mysql> select * from 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修复表

原文:https://www.cnblogs.com/chenjw-note/p/8184943.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!