2019-07-08mysql ibd 恢复数据

导入表空间的时候报错

ALTER TABLE ghq_item_category  IMPORT TABLESPACE;

ERROR 1808 (HY000): Schema mismatch (Table has ROW_TYPE_COMPACT row format, .ibd file has ROW_TYPE_DYNAMIC row format.)

网上说新建表的时候加上row_format=compact;就行了

我加上了可是还是不行，有人遇到同样的问题吗

CREATE TABLE `ghq_item_category` (

  `category_id` int(11) NOT NULL AUTO_INCREMENT,

  `category_name` varchar(10) NOT NULL,

  `order_id` int(11) NOT NULL DEFAULT '1',

  `create_time` datetime NOT NULL,

  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  `is_del` tinyint(1) NOT NULL DEFAULT '0' COMMENT '默认0: 不删除    1:删除',

  PRIMARY KEY (`category_id`)

) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8  row_format=compact;

地址：

https://www.oschina.net/question/2925231_2286093