Table is crashed and last repair failed

[samjoseph74]

When I am making certain modifications in the xyz table. While doing so, I encounter a power outage and my system shuts down unexpectedly. Again I switch on my system and try to open the table, the following error message gets displayed:

“Table is crashed and last repair failed”

The data saved in the xyz table becomes inaccessible after the error occurrence.Suggest me what I do to recover my data.

[SamuelAugy]

Maybe this would help you : myisamchk --max-record-length=1048576 -r -f <table_name>

You can see more details here : http://maheshsworld.jokesplanet.com/?q=mysql_crash

[Davidpoul]

Hi,

To resolve the above error message, you will need to repair xyz.myi table by using these steps:

1. To check and analyze the corrupted table, use either of the two commands:
myisamchk xyz.myi
Or
Check Table xyz
2. To repair the corrupted table, use either of the two commands:
myisamchk -r –q xyz (-r -q means “quick recovery mode”)
Or
Repair Table xyz

But if the above repair commands fail to repair the xyz table, you need to repair the table by using powerful MySQL Repair software. Such MySQL Database Repair applications incorporate advanced scanning algorithms to repair and restore the data stored in MyISAM tables.