Hi, I am trying to repair the table and i got this error
I tried with myisamchk --rq --tmpdir= /var/lib/mysql/tablog/TabEvents.MYI [root@uidsyslog001 mysql]# myisamchk --rq --tmpdir=/var/lib/mysql /var/lib/mysql/tablog/TabEvents.MYI check record delete-chain - recovering (with sort) MyISAM-table /var/lib/mysql/tablog/TabEvents.MYI Data records: 58354301 - Fixing index 1 Wrong bytesec: 0- 0- 0 at 15899573240; Skipped MyISAM-table '/var/lib/mysql/Syslog/SystemEvents.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 Then i tried the below one [root@> myisamchk --safe-recover --force --tmpdir=/var/lib/mysql /var/lib/mysql/tablog/TabEvents.MYI - recovering (with keycache) MyISAM-table '/var/lib/mysql /var/lib/mysql/tablog/TabEvents.MYI' Data records: 78918751 Wrong bytesec: 0- 0- 0 at 15899573240; Skipped Data records: 82882799 What might be the problem and how to make the table repair successfully. Guidance needed Thanks Ramesh
