Re: MyISAM Repair table problem
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. >> >> 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; +--++--++ | 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 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 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
Re: MyISAM Repair table problem
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, May 19, 2011 at 10:24 AM, Ramesh 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 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 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 >> > >
Re: MyISAM Repair table problem
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_frm ; >> >> >> On Thu, May 19, 2011 at 10:24 AM, Ramesh 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 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 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
Re: MyISAM Repair table problem
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; >> >> +--++--++ >> | 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 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 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 >
Re: MyISAM Repair table problem
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 | > > +--++--++ > | 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 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 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
Re: MyISAM Repair table problem
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 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 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 >
Re: MyISAM Repair table problem
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@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