Dear Marcos, Thanks for immediate your response...
Yaa, when i tried 'myisamchk -f vip_detail_tab' command, i got following error... Checking MyISAM file: /var/lib/mysql/db_slcs/vip_detail_tab Data records: 39642 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed and last repair failed - check file-size myisamchk: warning: Size of indexfile is: 1992704 Should be: 1024 - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 myisamchk: error: Can't read indexpage from filepos: -1 - recovering (with sort) MyISAM-table '/var/lib/mysql/db_slcs/vip_detail_tab.MYI' Data records: 39642 - Fixing index 1 myisamchk: Error writing file '/var/lib/mysql/db_slcs/vip_detail_tab.TMD' (Errcode: 28) myisamchk: error: 28 when writing to datafile MyISAM-table '/var/lib/mysql/db_slcs/vip_detail_tab' is not fixed because of errors Try fixing it by using the --safe-recover (-o) or the --force (-f) option with warm regards, viru ----- Original Message ----- From: "Marcos Oliva" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, November 27, 2003 11:53 AM Subject: RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
