Warning Code : 1478InnoDB: ROW_FORMAT=DYNAMIC requires innodb_file_format > Antelope.InnoDB: assuming ROW_FORMAT=COMPACT.

Warning Code : 1478InnoDB: ROW_FORMAT=DYNAMIC requires innodb_file_format > Antelope.InnoDB: assuming ROW_FORMAT=COMPACT.

오류시 다음과 같이 확인한다.

Before 5.7, table cannot be created Dynamic row-format with innodb_file_format= Antelope (Returns warning and table is created as Compact row-format)

5.7 can create Dynamic row-format table even innodb_file_format= Antelope, without any warnings and actually SHOW TABLE STATUS returns Row_format= Dynamic.

5.7's code checks innodb_file_format only when ROW_FORMAT= Compressed.

 https://bugs.mysql.com/bug.php?id=83647

 

Mysql버전문제일 가능성도 있다