全部博文(321)
分类: LINUX
2009-01-20 10:07:23
mysqldump: Got error: 144: Table ‘./DBNAME/TABLENAME’ is marked as crashed and last (automatic?) repair failed when using LOCK TABLES
可采用如下方法解决:
mysql>check table TABLENAME; +------------------------------+-------+----------+-------------------------------------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +------------------------------+-------+----------+-------------------------------------------------------------------------------------------------+ | DBNAME.TABLENAME | check | error | Table './DBNAME/TABLENAME' is marked as crashed and last (automatic?) repair failed | +------------------------------+-------+----------+-------------------------------------------------------------------------------------------------+ mysql>repair table TABLENAME; mysql>check table TABLENAME; +------------------------------+-------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------+-------+----------+----------+ | DBNAME.TABLENAME | check | status | OK | +------------------------------+-------+----------+----------+