今天从5.7mysqldump数据到5.6的时候遇到了ERROR 1031 (HY000) at line 33: Table storage engine for 'department' doesn't have this option错误

查看department建表语句

mysql> show create table department \G;
*************************** 1. row ***************************
Table: department
Create Table: CREATE TABLE `department` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '部门ID',
`code` varchar(64) NOT NULL COMMENT '组织结构code',
`name` varchar(90) NOT NULL COMMENT '部门名称',
`fullid` varchar(255) NOT NULL,
`fullname` text NOT NULL COMMENT '包括所有上级机构名称的全名称',
`pid` int(11) NOT NULL COMMENT '父ID',
`level` int(11) NOT NULL COMMENT '部门级别',
`issub` tinyint(1) NOT NULL COMMENT '是否有下级 0：没有； 1：有',
`del` tinyint(1) NOT NULL COMMENT '删除标记：0否1是',
PRIMARY KEY (`id`),
KEY `fullid` (`fullid`),
KEY `pid_del_idx` (`pid`,`del`),
KEY `idx_del` (`del`)
) ENGINE=InnoDB AUTO_INCREMENT=847 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='部门表'

问题应该是出在row_format上，继续查

ROW_FORMAT=DYNAMIC应该文件格式是barracude，修改之

重新导入，问题解决。

ITPub博客

MySQL　ERROR 1031 (HY000) at line 33: Table storage engine for