source error (ROW_FORMAT)

使用5.1mysqldump出来的备份集source恢复到5.5上，报错can not create table 'a' (errno:1478)

• 经排查发现建表语句ENGINE 与ROW_FORMAT不符

CREATE TABLE `a` (

…

)ENGINE=InnoDB  ROW_FORMAT=FIXED ;

• ENGINE 与ROW_FORMAT的对应关系

ENGINE	ROW_FORMAT(default)	ROW_FORMAT	ROW_FORMAT
InnoDB	COMPACT	REDUNDANT	COMPRESSED
MyISAM	Fixed	DYNAMIC

•  innodb_strict_mode参数测试
• innodb_strict_mode=0,create table warning->success

root@db1 11:41:45>show table status like '%a%'\G;

*************************** 1. row ***************************

           Name: a

         Engine: InnoDB

        Version: 10

     Row_format: Compact

           Rows: 21509

Avg_row_length: 122

    Data_length: 2637824

Max_data_length: 0

   Index_length: 2457600

      Data_free: 4194304

Auto_increment: 24081

    Create_time: 2012-08-31 23:23:16

    Update_time: NULL

     Check_time: NULL

      Collation: gbk_chinese_ci

       Checksum: NULL

Create_options: row_format=FIXED

• innodb_strict_mode=1,create table error->failure

• 解决方案：source文件前set global  innodb_strict_mode=0;完毕后set global  innodb_strict_mode=1;