can not find file *.MYI

2004-09-06 Thread 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

Re: can not find file *.MYI

2004-09-06 Thread 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 > > P