The index file will rebuild by using the above command. On Thu, May 19, 2011 at 11:16 AM, Ramesh <rames...@gmail.com> wrote:
> Is that index and all will be fine in that table, or have to create again? > > On 19 May 2011 11:11, 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