The index file will rebuild by using the above command.
On Thu, May 19, 2011 at 11:16 AM, Ramesh wrote:
> Is that index and all will be fine in that table, or have to create again?
>
> On 19 May 2011 11:11, Ramesh wrote:
>
>>
>> Lost all the records once i done the repair table with use_frm.
>>
Is that index and all will be fine in that table, or have to create again?
On 19 May 2011 11:11, Ramesh wrote:
>
> Lost all the records once i done the repair table with use_frm.
>
> On 19 May 2011 10:30, Suresh Kuna wrote:
>
>> Run this - repair table SystemEvents use_frm ;
>>
>>
>> On Thu, Ma
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 wrote:
>
> Lost all the records once i done the repair table with use_frm.
>
> On 19 May 2011 10:30, Suresh Kuna wrote:
>
>> Run this - repair table SystemEvents use_
Lost all the records once i done the repair table with use_frm.
On 19 May 2011 10:30, Suresh Kuna wrote:
> Run this - repair table SystemEvents use_frm ;
>
>
> On Thu, May 19, 2011 at 10:24 AM, Ramesh wrote:
>
>> mysql> repair table SystemEvents.frm;
>>
>> +--++-
Run this - repair table SystemEvents use_frm ;
On Thu, May 19, 2011 at 10:24 AM, Ramesh wrote:
> mysql> repair table SystemEvents.frm;
>
> +--++--++
> | Table| Op | Msg_type |
> Msg_text
mysql> repair table SystemEvents.frm;
+--++--++
| Table| Op | Msg_type |
Msg_text |
+--++--++
| SysEvents.frm
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 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@uidsyslo
