Re: can not find file *.MYI

[V. M. Brasseur]

Your index files appear to have disappeared during your archive.  You 
can rebuild them though.  Have a look at the "Table Maintenance and 
Crash Recovery" section of the manual:

http://dev.mysql.com/doc/mysql/en/Table_maintenance.html
Pay particular attention to the "REPAIR TABLE" syntax.  That will give 
you want you need.

Cheers,
--V
Yann Larrivee wrote:
Hi  keep getting this error "ERROR 1017: Can't find file: *.MYI".
What i did is simple , archived all the database files et placed them on a new 
server (i should have done a dump)

Now i can do a desc of all the table but i can't select any data from my 
tables.

Is there any way to recreate all the MYI files.
I don't really care about the content, but i dont feel like recreating all the 
structure.

I did look in the documentation, but it does not give any sugesiton on how to 
solve this issue.

Thanks.
Yann Larrivée

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]