阅读269 返回首页    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 “富养女儿，穷养儿”的真正内涵