can not find file *.MYI

[Yann Larrivee]

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




pgpfVzdzbSaXh.pgp
Description: signature

Re: can not find file *.MYI

[Yann Larrivee]

On September 6, 2004 18:33, V. M. Brasseur wrote:
 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,



As of MySQL 4.0.2, there is a USE_FRM mode for REPAIR TABLE. Use it if the 
`.MYI' index file is missing or if its header is corrupted. 

This seems to be my situation, but all my tables used to be innodb plus i am 
using 4.0.18 at this moment.

I did change the permissions to the proper group but it did not change 
anything to my situation.

Is there any other way to fix this without upgrading ?

Thanks

Yann Larrivée

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