List:General Discussion« Previous MessageNext Message »
From:Suresh Kuna Date:May 19 2011 4:05am
Subject:Re: MyISAM Repair table problem
View as plain text  
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 <ramesh4f@stripped> 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

Thread
MyISAM Repair table problemRamesh19 May
  • Re: MyISAM Repair table problemSuresh Kuna19 May
    • Re: MyISAM Repair table problemRamesh19 May
      • Re: MyISAM Repair table problemSuresh Kuna19 May
        • Re: MyISAM Repair table problemRamesh19 May
          • Re: MyISAM Repair table problemSuresh Kuna19 May
          • Re: MyISAM Repair table problemRamesh19 May
            • Re: MyISAM Repair table problemSuresh Kuna19 May