重新创建Mariadb数据库后,在导入时报了这两个错误:
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.
解决方案:
1、修改my.ini的[mysqld]下参数:
innodb_file_format=barracuda
innodb_file_per_table=true
innodb_large_prefix=true
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
max_allowed_packet=500M
2、修改原数据表的ROW_FORMAT为DYNAMIC,重新导出,再导入新库:
在导出库执行:
注:###为数据库名称
select concat('alter table ',table_name,' row_format=dynamic;') from information_schema.tables where table_schema='###';
执行运行出的结果集;
导出,再将数据重新导入新库。未再报错,导入成功。
引用:
https://www.cnblogs.com/Applogize/p/15217914.html
https://blog.csdn.net/u010317005/article/details/52206120