閱讀269 返回首頁    go 阿裏雲 go 技術社區[雲棲]

常見 mysql innodb 表錯誤

修複 mysql 過程中

mysql> check table itv_back.itv_score1;
+---------------------+-------+----------+----------------------------------------------------------------------------------------------+
| Table               | Op    | Msg_type | Msg_text                                                                                     |
+---------------------+-------+----------+----------------------------------------------------------------------------------------------+
| itv_back.itv_score1 | check | error    | Table rebuild required. Please do "ALTER TABLE `itv_score1` FORCE" or dump/reload to fix it! |
+---------------------+-------+----------+----------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

 

表需要重建

 

利用 show create table 

CREATE TABLE `itv_score1` (
  `activity_name` varchar(100) CHARACTER SET gbk DEFAULT NULL COMMENT '▒▒▒▒',
  `user_id` varchar(50) CHARACTER SET gbk DEFAULT NULL,
  `id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk


嚐試根據提示修複，返回錯誤信息

mysql> alter table itv_back.itv_score1 force;
ERROR 1030 (HY000): Got error -1 from storage engine


不支持 innodb 格式

隻能夠通過備份進行恢複。

最後更新：2017-04-03 16:49:02

  上一篇：go uclibc和glibc的差別
  下一篇：go “富養女兒，窮養兒”的真正內涵