Sams Teach Yourself MySQL in 21 Days, Second Edition

Q&A

Q1:	When I run a query, I'm getting a message from MySQL like “Got Error 127 from table handler.” Is my database corrupted?
A1:	Probably yes. But don't panic: Use myisamchk to check the table you suspect is corrupted without options and then using the -q, -m, and perhaps -e options. You can also add a -i for more information. Ideally you should shut down mysqld, or at least flush tables and try to ensure that myisamchk is the only thing accessing a table; otherwise, it might tell you that a table is corrupt when it isn't. If a problem is confirmed by any of these checks, commence the procedure outlined earlier for repairs.
Q2:	How can I find out more about these errors from the table handler?
A2:	If you're getting an error number, you can look ...