本文共 1151 字，大约阅读时间需要 3 分钟。

修复 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

只能够通过备份进行恢复。

转载地址：http://ypnni.baihongyu.com/