Re: Server-Crash - What to do? - Chris Knipe - com.mysql.lists.mysql

7 messages in com.mysql.lists.mysqlRe: Server-Crash - What to do?

From	Sent On	Attachments
Karel W. Dingeldey	27 Aug 2006 06:38
Karel W. Dingeldey	27 Aug 2006 10:53
Chris Knipe	27 Aug 2006 11:43
Martins	27 Aug 2006 11:43
Karel W. Dingeldey	27 Aug 2006 15:09
Chris Knipe	27 Aug 2006 15:25
Ludwig Pummer	28 Aug 2006 13:53

Subject:	Re: Server-Crash - What to do?
From:	Chris Knipe (sav...@savage.za.org)
Date:	08/27/2006 03:25:40 PM
List:	com.mysql.lists.mysql

On filesystem level I made all rescue trials. My problem is, that only the MYD file is still available. I tried reconstructing it with "myisamchk -r -o table_name.MYD", but as I said without the wanted result.

MYD is your data, MYI is your indexes (Indexes are easy to rebuild, you should not worry about that).

If myisamchk can't read the MYD, then I don't know what else there is. My guess would be that the data file is damage beyond repair :-(

If you have a complete and working set of binary logs (incase you used replication which I doubt), you should also be able to get your data back out of that... But otherwise, I'd say you're out of luck.