On 03-Jun-01 Derby wrote:
> Dear Everybody,
>
> Today I received the following error message in my web site (which
> is in php with mySql in UNIX environment), but it worked half a year
> until Today:
<snip>
>
> MySQL said: Got error 127 from table handler
>
> I suppose too many records are in the table.
> 4216, but it shouldn't be the reason :-(,
Nope, it's not.
> and unfortunately I am not allowed to delete any record from the
> database, because the records contain the information about
> subscripted users.
>
> 1, Do you know what can cause this error message?
> 2, What is the related exact error message text?
> 3, Where can I check the error message text, which related to error
> 127?
yes, & yes.
localhost.dread$ perror 127
Error code 127: Unknown error: 127
127 = Record-file is crashed
Something about your table is confused.
> 4, How can I solve this problem?
copy the table files to another directory, then in order of
increasing panic:
A. try droping & rebuilding your keys.
B. mysqldump --add-drop-table DB da_table > tbl.dmp
if it dumps ok, then mysql DB < tbl.dmp
C. run repair table ...
D. re-read the manual, shutdown the server
& then run myisamchk -r ...
E. restore from backup.
> 5, Do I have to change the mySql query, but how? And what is the
> reason that it worked half a year until now?
No, it's a valid query. it worked for months, right ?
Besides I've never heard of a query that would crash a table.
> 6, It should be some
change in php or UNIX, but what?
No changes, always shutdown the server properly, & you'll need to
learn how to backup and restore.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
---------------------------------------------------------------------
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
