From: Dehua Yang Date: October 19 2012 1:14pm Subject: Re: Table crashed error List-Archive: http://lists.mysql.com/mysql/228464 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf303bf8961fa4ac04cc694a5b --20cf303bf8961fa4ac04cc694a5b Content-Type: text/plain; charset=ISO-8859-1 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 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 --20cf303bf8961fa4ac04cc694a5b--