mysql解决迁移复制数据库报错 Key或column 过长

set global innodb_large_prefix=on;
show variables like '%innodb_large_prefix%';
set global innodb_file_format = BARRACUDA;
set global innodb_file_format_max = BARRACUDA;
show variables like '%innodb_file_format%';

所有表创建语句添加ROW_FORMAT=DYNAMIC