Error Code 127

[LittleSmudge]

My ( previously working ) MySQL database has suddenly started giving out code 127 error messages.


Where do I go to find out the meaning of this ( or err codes in general ) message.


What is the solution to this problem - any ideas ?





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[Bastien]

ever heard of google....found a huge list googling "mysql error code 127"

Its a filesystem crash...run repair table script on that table

Bastien

Cat, the other other white meat

 

[LittleSmudge]

Actually I first tried the MySQL.org site and found nothing there.

Second Search was Google. However, Google's 'huge list' as you call it, is just various chat sites and PHP coders talking about their own problems.


What I was really after was a source of MySQL defined Error Codes and what MySQL AB actually mean by them.

G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[KarveR]

It can also be incorrect permissions (i.e. no read or write for teh mysql daemon) on the data directory(ies).

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[LittleSmudge]

Thanks KarveR.

I actually found out the root cause.

Someone ( who is now making a slow but steady recovery ) decided to
COPY a table to a 'safe location'
Do some trial changes to the data
Didn't like the changes so 'copied back' ( overwrite ) the saved table files into the database folder

All the above on a running Service using Windows explorer to do the copy/overwrite.


Trust me, they won't be doing that again in a hurry !


The fix was to stop MySQL, then replace the table, restart MySQL
And now all is well.
( it's just as well that we only have user activity on the db 8 hours a day. )


Thanks for your help .






G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.