mysql [Err] 1071 - Specified key was too long； max key length is 767 bytes

查找的资料：

https://blog.csdn.net/u010030022/article/details/80967516
https://blog.csdn.net/ACMAIN_CHM/article/details/4174186
https://www.cnblogs.com/kerrycode/p/9680881.html

一、问题

在其他数据库导出数据到新数据库，出现[Err] 1071 - Specified key was too long; max key length is 767 bytes

因为字符集使用不同，key的长度也会有所不同，如下图

 

 

二、查看原数据库的字符集，修改字符集

mysql> show variables like 'char%';

+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8mb4                    |
| character_set_connection | utf8mb4                    |
| character_set_database   | utf8mb4                    |
| character_set_filesystem | binary                     |
| character_set_results    | utf8mb4                    |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

修改目标数据库的字符集

set character_set_client='utf8mb4';
set character_set_connection='utf8mb4';
set character_set_database='utf8mb4';
set character_set_results='utf8mb4';
set character_set_server='utf8';