List:General Discussion« Previous MessageNext Message »
From:Suresh Kuna Date:May 19 2011 5:00am
Subject:Re: MyISAM Repair table problem
View as plain text  
Run this - repair table SystemEvents use_frm ;


On Thu, May 19, 2011 at 10:24 AM, Ramesh <ramesh4f@stripped> 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 <sureshkumarilu@stripped> 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 <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
>>
>
>


-- 
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