10 July 2006

MySql error

I guess I must have shutdown a LINUX system before MySQL has stopped as I have a corrupt table. The message I got was:

DBD::mysql::db do failed: Got error 127 from table handler at .......

Issued perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed

It was easy to fix by

  1. cd path to database tables
  2. myisamchk -r dns_ip_2_host.MYI


Next time I will try
mysql dbname
REPAIR TABLE `dns_ip_2_host`

No comments: