Re: Deleted index file (.MYI)

[Sergei Golubchik]

Hi!

On Jul 16, Oswaldo Castro wrote:
> Hi Everybody
> 
> I have acidentally deleted an index file (.MYI) from a table. Is there
> another way, besides its backup, to recover this table ?
> 
> Thanks for any help

Yes.
Backup your MYD file (just in case)
and try REPAIR ... USE_FRM

or create dummy MYI file, TRUNCATE TABLE, restore MYD file (you backed
it up, didn't you ?), REPAIR TABLE

Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com