数据库'表名' is marked as crashed and should be repaired
来源:互联网 发布:都叫兽数据恢复 编辑:程序博客网 时间:2024/05/02 07:25
解决方法:
进入/usr/bin下,执行命令
zx@zx-Lenovo-Product:/usr/bin$ ./myisamchk -c -r /var/lib/mysql/Microblog/PL2F_1_ftb_mb026.MYI(数据库表名的完整路径)
可能会提示如下错误:
- recovering (with sort) MyISAM-table '/var/lib/mysql/Microblog/PL2F_1_ftb_mb026.MYI'
Data records: 193511
- Fixing index 1
Found link that points at 74158072 (outside data file) at 3294092
- Fixing index 2
- Fixing index 3
./myisamchk: Can't change permissions of the file '/var/lib/mysql/Microblog/PL2F_1_ftb_mb026.MYD' (Errcode: 1)
myisamchk: error: 1 when fixing table
MyISAM-table '/var/lib/mysql/Microblog/PL2F_1_ftb_mb026.MYI' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag
zx@zx-Lenovo-Product:/usr/bin$ ./myisamchk -c -r -f -o /var/lib/mysql/Microblog/PL2F_1_ftb_mb026.MYI
- recovering (with keycache) MyISAM-table '/var/lib/mysql/Microblog/PL2F_1_ftb_mb026.MYI'
Data records: 193511
Found link that points at 74158072 (outside data file) at 3294092
./myisamchk: Can't change permissions of the file '/var/lib/mysql/Microblog/PL2F_1_ftb_mb026.MYD' (Errcode: 1)
myisamchk: error: 1 for record at pos 73838964
MyISAM-table '/var/lib/mysql/Microblog/PL2F_1_ftb_mb026.MYI' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag
解决方法:(注意简单使用chmod来改变表的权限是不起作用的)
运行如下命令:
zx@zx-Lenovo-Product:/usr/bin$ sudo ./myisamchk -c -r /var/lib/mysql/Microblog/PL2F_1_ftb_mb026.MYI(数据库表名的完整路径)
- 数据库'表名' is marked as crashed and should be repaired
- 表 is marked as crashed and should be repaired
- mysql Table "表名" is marked as crashed and should be repaired
- 解决数据库 Table 'content_tags' 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)
- mysql错误:is marked as crashed and should be repaired
- Table 'table_name' 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
- 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
- 解决“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
- 解决MYSQL数据库 Table ‘xxx’ is marked as crashed and should be repaired 145错误
- 诸子百家:谁是云计算真正的幕后推手
- MessageBox的常见用法
- SICP ex1.11
- Qtopia在arm上的移植错误:cannot find -luuid .
- JOJ2510:Product
- 数据库'表名' is marked as crashed and should be repaired
- Oracle Golden Gate 系列十一 -- 配置 GG DDL 同步 说明 与 示例
- 拖拽文本/链接到地址栏
- 如何手动注册mscomm
- 初涉Android蓝牙开发
- 山寨怎么说
- 如何让expect进程后台执行
- c语言关键字volatile的用法3
- 使用jquery实现的漂亮的滚动图片