Re: Q: How to recreate lost .MYI files

2001-03-23 Thread Carsten Gehling
From: "Peter Skipworth" <[EMAIL PROTECTED]> Sent: Friday, March 23, 2001 11:43 PM > Try copying your .MYD and .frm files to a directory and running 'restore > table [tablename] from '/this/directory' Thank you very much :-) - Carsten

Re: Q: How to recreate lost .MYI files

2001-03-23 Thread Peter Skipworth
Try copying your .MYD and .frm files to a directory and running 'restore table [tablename] from '/this/directory' regards, P On Fri, 23 Mar 2001, Carsten Gehling wrote: > I have to MYISAM tables where I... ahem... have lost the corresponding .MYI > files. When I try to repair the tables, myis

Q: How to recreate lost .MYI files

2001-03-23 Thread Carsten Gehling
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