|
|
ERROR 1071 (42000) at line 162: Specified key was too long; max key length is 767 bytes
7 ?- m8 @$ w, s* R: Z6 F+ q5 M+ x" m4 \
导入数据库时报错：
3 g) [7 v4 O8 _4 H n5 f[mysqld]
+ E* S x) ~; j! M3 }" a. F5 A) ~2 {# O- x l. g3 h8 L8 T }
innodb_file_format = Barracuda5 i9 B1 y3 L8 G& z
innodb_file_format_check = ON
0 h# e- H- S) ]0 ^3 j3 Hinnodb_file_format_max = Barracuda- U$ l; y* u9 d& [! A8 n
[mysql.server]; V; r" D+ i4 j$ M" z) Y$ e
innodb_file_format = Barracuda5 E4 Y! Q0 R8 ?) Z+ H
innodb_file_format_check = ON& J& h6 C8 F$ U( n% j7 k* s% a# g
innodb_file_format_max = Barracuda
" n+ Z+ W# P' X
8 N, { j/ q9 W$ K+ n. E; x. D) S7 A. l8 e9 P# V. k
在my.cnf文件中添加上面信息：
8 z/ g! H/ ~7 c, v8 b4 P" q" z7 j. Y4 B0 e* {% z& W
collation-server = utf8mb4_general_ci9 A. N" o$ W/ t6 X+ F; L
init-connect = 'SET NAMES utf8mb4'8 Q( R2 E9 }5 }5 l$ Y
character-set-server = utf8mb44 a+ E# K0 R. c$ Z
innodb_file_format = Barracuda$ d5 e% ~% k" K6 e
innodb_file_format_check = ON
4 W! U+ _% i8 \2 Q- U$ hinnodb_file_format_max = Barracuda, R8 T- g- L/ S& c+ @: D
innodb_large_prefix = ON! W. B9 A, n" E0 P
[mysql.server]
2 T. y& r" R" v# r# Yinnodb_file_format = Barracuda6 }7 {9 W* Q! |6 ^
innodb_file_format_check = ON7 ? }( @7 W% y- m/ F
innodb_file_format_max = Barracuda- l$ D9 x2 p" Z0 k1 J
innodb_large_prefix = ON
' ^/ q& A& u- c# Udefault-character-set = utf8mb4
% O5 e! d- l2 M# Z6 mcharacter_set_server = utf8mb4
) |- N* `) P" W7 @7 J% e[client]. h3 ~8 v' U- m
default-character-set = utf8mb4: r# |$ N( M2 a( G, ~- z8 @
[mysqld_safe]$ s4 I& D0 {* S+ Z
default-character-set = utf8mb4
9 A, Q& s K( C
5 o! n- Z8 t: z: b |
|
发表于 2022-10-26 10:00:33