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

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

查看department建表语句

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

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

1. mysql> show variables like 'innodb_file_format';
   
2. +--------------------+----------+
   
3. | Variable_name | Value |
   
4. +--------------------+----------+
   
5. | innodb_file_format | Antelope |
   
6. +--------------------+----------+
   
7. 1 row in set (0.00 sec)

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

1. set global innodb_file_format=barracuda;

重新导入，问题解决。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20893244/viewspace-2138132/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20893244/viewspace-2138132/