SOLVED-[ERROR] mysqld: Table ‘./eximstats/defers’ is marked as crashed and should be repaired

0

Messages such as [ERROR] mysqld: Table ‘./eximstats/defers’ is marked as crashed and should be repaired normally appear when some database in your server crashes. Commands such as

mysqlcheck -u root --check auto-repair --optimize all-databases

root@server[/home/user]# myisamchk /var/lib/mysql/eximstats/sends.MYI

hardly work. one command that has been known to work is

 

myisamchk /var/lib/mysql/eximstats/sends.MYI -r

root@server[/home/user]# myisamchk /var/lib/mysql/eximstats/sends.MYI -r
- recovering (with sort) MyISAM-table '/var/lib/mysql/eximstats/sends.MYI'
Data records: 904
- Fixing index 1
- Fixing index 2
- Fixing index 3

SOLVED-[ERROR] mysqld: Table ‘./eximstats/defers’ is marked as crashed and should be repaired

 

Share.

About Author

Comments are closed.