On updating character2 table to version 22.1.1, faced a trouble with adding Rel21_04_001_update_deprecated_ROW_FORMAT.sql into db.
It reports that MySQL can't complete a request "ALTER TABLE groups ROW_FORMAT=DYNAMIC ENGINE=INNODB;"
After a search in a Google, I found that there is a kind of troubles with dynamic row format in InnoDB in MySQL 8 (v 8.0.22), and solved a problem by simple removing this string from update file (i.e., row format for this table leaved unchanged, i.e., MyISAM). All other fields changed correctly. Now all works fine, but just reporting to you about this trouble.
Recommended Comments