>RH> I'm using MySQL 3.23.51. I have a table which started giving 127 errors. > >[skip] > >RH> It "recovers" my table but I end up with only 1030 out of 27497 rows, >RH> so that's not a log of help! > >RH> Running myisamchk -r -e gives a similar result (only 1030 rows are >RH> recovered), as does truncating the table first then restored the MYD >RH> file and running myiasmchk. > >RH> Any other suggestions as to what to try? > >Could you repair table with REPAIR TABLE .. USE_FRM ?
Thanks for the the suggestion. 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 mean? Regards, -Rolf -- Rolf Howarth, Square Box Systems Ltd, Stratford-upon-Avon UK. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php