Corrupt table recovery

2002-09-05 Thread Rolf Howarth
entation on the structure of MYD files, but fortunately I managed to persevere. I'm curious why myisamchk did such a poor job of it, though, given that virtually all the data still seemed to be recognisably there? -Rolf [Spam filter fodder: sql, query, ...] -- Rolf Howarth, Square Box Sy

Re: Help! Recovering corrupt table

2002-09-02 Thread Rolf Howarth
n. What does USE_FRM mean? That gives a syntax error. If I do a plain REPAIR TABLE then it has the same effect as myisamchk, just giving me 1030 out of 27000+ rows! >Does it also deletes records? Not sure what you m

.MYD/.MYI file formats

2002-09-02 Thread Rolf Howarth
Are the MySQL MYD/MYI file formats documented anywhere? Are they any utilities that will dump these out for debug purposes? -Rolf -- Rolf Howarth, Square Box Systems Ltd, Stratford-upon-Avon UK. - Before posting, please check

Help! Recovering corrupt table

2002-09-02 Thread Rolf Howarth
"recovers" my table but I end up with only 1030 out of 27497 rows, so that's not a log of help! Running myisamchk -r -e gives a similar result (only 1030 rows are recovered), as does truncating the table first then restored the MYD file and running myiasmchk. Any other sug