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]
