Search This Blog

Sunday, November 18, 2018

Fix ROW_FORMAT mismatch in MySQL

Error: Schema mismatch (Table has ROW_TYPE_DYNAMIC row format, .ibd file has ROW_TYPE_COMPACT row format.

alter table mytable ROW_FORMAT=COMPACT;