Q: How to recreate lost .MYI files

["Carsten Gehling" <carsten@xxxxxxxx>]

I have to MYISAM tables where I... ahem... have lost the corresponding .MYI
files. When I try to repair the tables, myisamchk reports this error:

myisamchk: error: 'questions.XXX' doesn't have a correct index definition.
You need to recreate it before you can do a repair

How do I recreate these indexes?

- Carsten



---------------------------------------------------------------------
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 <mysql-thread69345@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php