Databasename/Tablename is marked as crashed and should be repaired

2011-10-14 Thread James
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 disadvantage of MyISAM.

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

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 m...@good-stuff.co.uk 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

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

2011-10-14 Thread Johan De Meersman
- Original Message - From: Suresh Kuna sureshkumar...@gmail.com 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

Additional Software to Download and Install

2011-10-14 Thread AndrewMcHorney
Hello I just downloaded the MySql server software. I am now looking for software that is gui based and will allow me to easily define a database, create tables and to do updates of records within the tables. It would be fantastic if the software had report generating capabilities and also

Re: Additional Software to Download and Install

2011-10-14 Thread Neil Tompkins
Try the MySQL workbench software On 14 Oct 2011, at 19:12, AndrewMcHorney andrewmchor...@cox.net wrote: Hello I just downloaded the MySql server software. I am now looking for software that is gui based and will allow me to easily define a database, create tables and to do updates of

RE: Additional Software to Download and Install

2011-10-14 Thread Jason Trebilcock
I'm a fan of Toad for MySQL. http://toadformysql.com/index.jspa -Original Message- From: AndrewMcHorney [mailto:andrewmchor...@cox.net] Sent: Friday, October 14, 2011 1:12 PM To: mysql@lists.mysql.com Subject: Additional Software to Download and Install Hello I just