Hi Reindl
I had tested your method serval months ago.
When i had a crash table, I added myisam-recover = "FORCE" to my.cnf
and restarted mysqld.
But it didn't work
So, finally, we just had to do this repairment by application code.
On Fri, Oct 19, 2012 at 4:59 PM, Reindl Harald <h.reindl@stripped>wrote:
>
>
> Am 19.10.2012 08:42, schrieb Dehua Yang:
> > MyISAM storage tables also have this kind of problem.
> >
> > I have try serval solutions for this problem , but can't work very well.
> >
> > If your application isn't very import , you can let your application auto
> > repair this problem.
> > Just like this :
> > When your application catch this error information , run check table xxx.
>
> oh no, do not write useless code in the application
> for things the server is able to do
>
> my.cnf:
> myisam-recover = "FORCE"
>
>
--
Gtalk : meflyingfish@stripped
Skype name : meflyingfish
Twitter: http://twitter.com/whitepoplar