Table '.\xxxxx\xxxx' is marked as crashed and should be repaired 解决办法
来源：互联网 发布：淘宝怎么看几颗心 编辑：程序博客网 时间：2024/06/13 17:21
整个备忘，今天在后台重启服务器的时候，发现一个数据表的索引被破坏了，只怪自己强制重启啊。
问题：Table ‘.\xxxxx\xxxx’ is marked as crashed and should be repaired？
找下mysql的安装目录下的bin/myisamchk
myisamchk -c -r ../data/xxxxx/xxxx.MYI
这样就可以恢复数据表的索引了。不需要重启，很方便把！
错误的产生的原因，数据库服务器的突发性的断电，就像我一样，强启服务器，可能会导致mysql数据库表被损坏而无法读取数据。
阅读全文
0 0
- Table '.\xxxxx\xxxx' is marked as crashed and should be repaired 解决办法
- mysql:Table 'xxxxx' is marked as crashed and should be repaired
- Mysql断电mysql:Table 'xxxxx' is marked as crashed and should be repaired
- Table 'table_name' is marked as crashed and should be repaired
- Table 'xxxxxxx' is marked as crashed and should be repaired
- Table ‘xxx’ is marked as crashed and should be repaired ...
- linux Table is marked as crashed and should be repaired
- Table '.\tablename' is marked as crashed and should be repaired
- Table 'user_xxxxx' is marked as crashed and should be repaired
- Table is marked as crashed and should be repaired
- 修复 Table marked as crashed and should be repaired
- Table xxxis marked as crashed and should be repaired
- 表 is marked as crashed and should be repaired
- mysql错误：is marked as crashed and should be repaired
- is marked as crashed and should be repaired
- mysql错误is marked as crashed and should be repaired
- 解决“is marked as crashed and should be repaired”
- repair table `site_user`,#1194 – Table is marked as crashed and should be repaired错误修复
- centos升级内核
- spark 安装与python pycharm搭建
- 如何在官网下载JDK（版本、系统类型、字节位等）
- java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
- 框架，系统架构以及架构师的区别
- Table '.\xxxxx\xxxx' is marked as crashed and should be repaired 解决办法
- RTSP协议
- HTML知识点
- List的toArray方法的使用方法以及强制转换时的报错问题
- mysql全量和增量备份脚本
- java反射机制
- 比特币扩容与分叉
- Spring AOP底层实现
- fio数据生成曲线图
