From: Ramesh
Date: May 19 2011 4:00am
Subject: MyISAM Repair table problem
List-Archive: http://lists.mysql.com/mysql/225022
Message-Id: <BANLkTimKXv_JGjLnX8cASsrPH0=YLPKtMA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0016e6db2a8fcc3b6a04a3990b4c

--0016e6db2a8fcc3b6a04a3990b4c
Content-Type: text/plain; charset=ISO-8859-1

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

--0016e6db2a8fcc3b6a04a3990b4c--