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

>
> Lost all the records once i done the repair table with use_frm.
>
> On 19 May 2011 10:30, Suresh Kuna <sureshkumarilu@stripped> wrote:
>
>> 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
>>
>
>


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