Table Crashed

[Robbie2003]

Robbie2003 (IS/IT--Manageme) Mar 26, 2004
Hi

I am new to MYSQL and hoped for some advice on the following.

I am unable to access one of my tables, when I try to access it I get the following massage.

Database wrm - Table wrm_tellafriend running on localhost
Error

SQL-query :

SELECT *
FROM `wrm_tellafriend`
LIMIT 0 , 30

MySQL said:


#1016 - Can't open file: 'wrm_tellafriend.MYD'. (errno: 145)

I have run a check on the same table and got the following result.


Table Op Msg_type Msg_text
wrm.wrm_tellafriend check warning Table is marked as crashed
wrm.wrm_tellafriend check warning 10 clients is using or hasn't closed the table pro...
wrm.wrm_tellafriend check warning Size of indexfile is: 676389888 Should be: 67...
wrm.wrm_tellafriend check error Record at pos: 641174436 is not remove-marked
wrm.wrm_tellafriend check error record delete-link-chain corrupted
wrm.wrm_tellafriend check error Corrupt

I have used the repair table option but this does not seemed to have worked is their any other options to recover this table.








Inappropriate post?
If so, Red Flag it!


Check out the FAQ
area for this forum!




Tek-Tips Forums is Member Supported. Click Here to donate.
TonyGroves (Programmer) Mar 26, 2004
Have you tried REPAIR TABLE EXTENDED or REPAIR TABLE USE_FRM?


Thank TonyGroves for this valuable post!


Inappropriate post?
If so, Red Flag it!


Check out the FAQ
area for this forum!



Robbie2003 (IS/IT--Manageme) Mar 26, 2004
No I have not tried these as I do not know how to I only seem to be able to find the option that says repair table as shown below, I would be very grateful if you would be kind enough to explain to me how I can find and use these options.

Drop
Empty
Print view
Optimize Table
Check Table
Repair Table
Analyze Table

These are the only options I can find.