Atomicorp

Unfortunately that won't work on the majority of the damaged tables (in my experience). They need to be dumped and reloaded. That's the annoying/dangerous thing.

Faris.

Works fine in the majority of cases in my experience. If a REPAIR doesn't work, then usually the data is really corrupted and it's also no longer possible to create a correct dump. YMMV, you can always give it a shot.

Thanks Breun (as usual!)

I'm going from memory here, but as I recall a lot of the tables that get into this state give an error similar to "table type (whatever it is) does not support repair - dump and restore instead". That's paraphrasing the error -- it is something else really.

In one of the posts there's something similar. It says
but this isn't precicely the error I'm thinking about.

Not all storage engines support REPAIR, that's correct. According to http://dev.mysql.com/doc/refman/5.1/en/ ... table.html only MyISAM, ARCHIVE and csv tables support REPAIR. See http://dev.mysql.com/doc/refman/5.1/en/ ... ables.html for more information on repairing tables.