restart the MySQL server happened to me this week when I was copying files (and changing the schema) while the server was running
HTH Dave -----Original Message----- From: Frederic Dhorne [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 15:32 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: ERROR 1030: Got error 127 from table handler / Optimize Table Hello, I am using mysql 3.23.38 on winnt. I have a table already filled with default value, that way we do only updates during our processing. One column is specified as not null in the table definition and it's also an index. everything was working fine, Until we decided to use "Optimize Table". now I am not getting anymore all the rows. Moreover in some cases, I'm getting the following error: ERROR 1030: Got error 127 from table handler. is there anyway to move around this, while I keep the call to Optimize Table? PS: myisamchk -r -q .... doesn't generate any trouble. Thanks --------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php