Re: Table handler errors

2005-04-24 Thread Richard Lynch
On Sun, April 24, 2005 5:20 am, Mike Blezien said: > we started getting these table handler errors 12, not all the time, but > just now > then. this is a FreeBSD 4.9-RELEASE O/S, w/MySQL 4.0.24 installed. The > database > in question is used by this vBulletin BBS system. Not sure it's a problem > w

RE: Table handler errors

2005-04-24 Thread mathias fatene
sec) if you redefine it, it may work better in memory. Else use temporary tables. Mathias -Original Message- From: Jigal van Hemert [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 17:08 To: [EMAIL PROTECTED] Cc: MySQL List Subject: Re: Table handler errors > Yes, I've going

Re: Table handler errors

2005-04-24 Thread Jigal van Hemert
> Yes, I've going through the docs and the manual i have hear locally, couldn't > really find a specific reason and/or causing for the error. The table type that > was causing the error was a HEAP table, changed it to a MyISAM table type and > the error disappeared, no more handler errors now... go

Re: Table handler errors

2005-04-24 Thread Mike Blezien
Jigal van Hemert wrote: From: "Mike Blezien" we started getting these table handler errors 12, not all the time, but just now For errors from the operating system you can use perror to find out the description of the code: http://dev.mysql.com/doc/mysql/en/perror.html Regards, Jigal. Yes, I've goi

Re: Table handler errors

2005-04-24 Thread Jigal van Hemert
From: "Mike Blezien" > we started getting these table handler errors 12, not all the time, but just now For errors from the operating system you can use perror to find out the description of the code: http://dev.mysql.com/doc/mysql/en/perror.html Regards, Jigal. -- MySQL General Mailing List F

Re: Table Handler Errors

2002-11-23 Thread Bhavin Vyas
possible table corruption. Run myisamchk on the table to check it and then, if needed, repair it. Bhavin. - Original Message - From: "Amit Lonkar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 22, 2002 10:52 PM Subject: Table Handler Errors > Hi All! > > I am using m