Dear Srinivas, I tried this option too like, REPAIR TABLE vip_detail_tab QUICK, but i got following error..
+------------------------+--------+----------+------------------------------ -------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +------------------------+--------+----------+------------------------------ -------------------------------------------------+ | db_slcs.vip_detail_tab | repair | error | Couldn't fix table with quick recovery: Found wrong number of deleted records | | db_slcs.vip_detail_tab | repair | error | Run recovery again without -q | | db_slcs.vip_detail_tab | repair | error | 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | error | 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | status | Operation failed | +------------------------+--------+----------+------------------------------ -------------------------------------------------+ 5 rows in set (1.06 sec) facing critical problem... regards, viru ----- Original Message ----- From: "chekuri raju" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, November 27, 2003 12:16 PM Subject: RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) > Hai Viru, > > even i had the same problem some time back could fix it with this below command > mysql>repair table vip_detail_tab; > u can look at the help options under mysql command prompt > > srinivas > > Marcos Oliva <[EMAIL PROTECTED]> wrote: > Viru, > > have you tried looking into the MySQL errro 144 ?, you may have to issue the myisamchk with the -force option > and see if that helps > > marcos oliva > > > -----Original Message----- > From: virupaksha [mailto:[EMAIL PROTECTED] > Sent: Wed 11/26/2003 6:42 PM > To: Struts Users Mailing List > Cc: > Subject: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) > > > > Dear All, > > I am very sorry to ask MySQL releted question in Struts group.. > > i am facing this problem since one week but couldn't able to sovle... > > could any one faced following error before..? > > while accessing table called vip_detail_tab, i m getting following error.. > > Can't open file: 'vip_detail_tab.MYD'. (errno: 144) > > i feel this table may corrupted.. > > expecting some ray of hope from this group..:( > > Regards, > viru > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------- > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]