Viru,
Ok then have you tried using the "REPAIR TABLE QUICK" or else try dumping the data
from the table to a delim file and recreating the table .
marcos
-----Original Message-----
From: virupaksha [mailto:[EMAIL PROTECTED]
Sent: Wed 11/26/2003 7:03 PM
To: Struts Users Mailing List
Cc:
Subject: Re: Can't open file: 'vip_detail_tab.MYD'. (errno: 144)
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
