use repair table table_name use_frm ; and try it out. It needs to be run inside mysql.
On Thu, May 19, 2011 at 9:30 AM, Ramesh <rames...@gmail.com> wrote: > 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 > -- Thanks Suresh Kuna MySQL DBA
