Re: Databasename/Tablename is marked as crashed and should be repaired

2011-10-14 Thread Johan De Meersman
- Original Message - > From: "Suresh Kuna" > > The permanent solution is to convert the table into Innodb engine. Wonderful advice, especially without even bothering to try and find out what is actually causing the corruption. Well done, that man. You *are* aware that not all tables ca

Re: Databasename/Tablename is marked as crashed and should be repaired

2011-10-14 Thread Suresh Kuna
Hi, The permanent solution is to convert the table into Innodb engine. Thanks Suresh Kuna On Fri, Oct 14, 2011 at 1:00 PM, Mark Goodge wrote: > On 14/10/2011 08:07, James wrote: > >> Hello, >> >> I have the following error on my mysql server log and managed to repaired >> the broken table. How

Re: Databasename/Tablename is marked as crashed and should be repaired

2011-10-14 Thread Mark Goodge
On 14/10/2011 08:07, James wrote: Hello, I have the following error on my mysql server log and managed to repaired the broken table. However, it keeps occurring by time to time. I am using MyISAM storage engine to all database and having some locking table which I know / aware about the disadvan