Table crashed

[Robbie2003]

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.

 

[TonyGroves]

Have you tried [tt]REPAIR TABLE EXTENDED[/tt] or [tt]REPAIR TABLE USE_FRM[/tt]?

 

[Robbie2003]

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.

 

[TonyGroves]

The syntax is:

[tt]REPAIR TABLE tblname USE_FRM[/tt]

or

[tt]REPAIR TABLE tblname EXTENDED[/tt]

Just enter them as SQL queries using any MySQL client.