Can you paste the table files in the datadir and the execution part of the below query.
On Thu, May 19, 2011 at 11:11 AM, Ramesh <rames...@gmail.com> wrote: > > Lost all the records once i done the repair table with use_frm. > > On 19 May 2011 10:30, Suresh Kuna <sureshkumar...@gmail.com> wrote: > >> Run this - repair table SystemEvents use_frm ; >> >> >> On Thu, May 19, 2011 at 10:24 AM, Ramesh <rames...@gmail.com> wrote: >> >>> mysql> repair table SystemEvents.frm; >>> >>> +------------------+--------+----------+----------------------------------------+ >>> | Table | Op | Msg_type | >>> Msg_text | >>> >>> +------------------+--------+----------+----------------------------------------+ >>> | SysEvents.frm | repair | Error | Table 'SysEvents.frm' doesn't exist >>> | >>> | SysEvents.frm | repair | error | >>> Corrupt | >>> >>> +------------------+--------+----------+----------------------------------------+ >>> 2 rows in set (0.00 sec) >>> >>> But the SysEvents.frm is there in the datadir. >>> >>> >>> >>> On 19 May 2011 09:35, Suresh Kuna <sureshkumar...@gmail.com> wrote: >>> >>>> 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 >>>> >>> >>> >> >> >> -- >> Thanks >> Suresh Kuna >> MySQL DBA >> > > -- Thanks Suresh Kuna MySQL DBA
