升级mysql5.7.9后数据的恢复Table storage engine for 'supplier' doesn't have this option

这两天把mysql升级到5.7.9了，恢复数据时出了2问题

1、引擎用innodb

在备份时备份的一个表结构如下：

CREATE TABLE `adjpricebill` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fbillerid` varchar(25) DEFAULT '' COMMENT '制单人',
  `fbillno` varchar(25) CHARACTER SET gbk COLLATE gbk_bin NOT NULL DEFAULT '' COMMENT '单号',
  `fbilltypeid` varchar(25) DEFAULT '' COMMENT '单据类型1外购入库2外购出库3产品入库4产品出库',
  `fchekerdate` datetime DEFAULT NULL COMMENT '审核日期',
  `fcheckerid` varchar(25) DEFAULT '' COMMENT '审核人',
  `fconsignee` varchar(25) DEFAULT '' COMMENT '收货方',
  `fdate` varchar(15) DEFAULT '' COMMENT '单据日期',
  `fdeptid` varchar(25) DEFAULT '' COMMENT '部门',
  `fempid` varchar(25) DEFAULT '' COMMENT '业务员',
  `fexplanation` varchar(45) DEFAULT '' COMMENT '摘要',
  `fmanagerid` varchar(25) DEFAULT '' COMMENT '主管',
  `ffmanagerid` varchar(25) DEFAULT '' COMMENT '验收人',
  `fnote` varchar(45) DEFAULT '' COMMENT '备注',
  `frob` tinyint(4) DEFAULT '0' COMMENT '红蓝标记 1蓝 2红',
  `fsmanagerid` varchar(25) DEFAULT '' COMMENT '保管人',
  `fsupplyid` varchar(25) DEFAULT '' COMMENT '供应商',
  `fwarehouse` varchar(25) DEFAULT '' COMMENT '仓库',
  `fyear` smallint(5) unsigned DEFAULT '0',
  `fperiod` tinyint(3) unsigned DEFAULT '0',
  `fkeeperid` varchar(25) DEFAULT '0',
  `fdeleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除',
  `fac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否核算过',
  `fempname` varchar(25) NOT NULL DEFAULT '',
  `voucherid` varchar(25) DEFAULT '',
  `fwarehouse2` varchar(25) DEFAULT '',
  `fchecked` tinyint(4) DEFAULT '0' COMMENT '是否审核',
  `fusesid` varchar(25) DEFAULT NULL COMMENT '领料用途',
  PRIMARY KEY (`id`),
  KEY `Index_2` (`fbillno`,`fdate`,`fempname`) USING BTREE,
  KEY `Index_3` (`fbillno`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk ROW_FORMAT=FIXED  COMMENT='出入库明细表';

恢复时出错了

后来发现不知道什么原因  ROW_FORMAT=FIXED不能用了 提示Table storage engine for 'supplier' doesn't have this option

删除  ROW_FORMAT=FIXED即可

2、执行如下两句也出错Table storage engine for 'supplier' doesn't have this option

ALTER TABLE `adjpricebill` DISABLE KEYS

ALTER TABLE `adjpricebill` ENABLE KEYS

最后不得已 注释掉即可

--40000 ALTER TABLE `adjpricebill` DISABLE KEYS --
--40000 ALTER TABLE `adjpricebill` ENABLE KEYS --