数据库'表名' is marked as crashed and should be repaired

本文介绍了一种解决MyISAM表修复过程中遇到特定错误的方法。通过使用myisamchk工具的不同选项，如--safe-recover和--force，并结合sudo权限进行操作，成功解决了无法更改文件权限的问题。

解决方法：

进入/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