|
|
ERROR 1071 (42000) at line 162: Specified key was too long; max key length is 767 bytes9 V# R( ~" O* O4 d2 N) G
- A& h, n% P; p z导入数据库时报错：/ D3 Y+ K: K3 J1 }2 e5 N
[mysqld]6 v3 w5 P- }* Q) n) o v# I5 z
8 m% A' H- @6 z! Pinnodb_file_format = Barracuda/ ]3 @8 N: Z) J: O: l4 w! `
innodb_file_format_check = ON
3 |) H/ @ ~& W6 C0 m+ N+ ]innodb_file_format_max = Barracuda* h% X8 f& v1 g5 @7 V- V3 G
[mysql.server]6 n5 s) u8 S" v& d% V. M
innodb_file_format = Barracuda
( j; e" W* n# N) r, }3 _innodb_file_format_check = ON+ g* @& X) P- U7 A3 @7 \. w
innodb_file_format_max = Barracuda/ ^; h. n1 ]) h6 \( I( b1 I6 c
0 _* Y! l0 B% Q' p, \9 I) B
i5 b) S9 e7 z在my.cnf文件中添加上面信息：
$ g& a" ?5 N7 `+ J! p o
8 i9 C' i1 S9 N# K% Zcollation-server = utf8mb4_general_ci
) D& ^- r/ K7 R. k. {init-connect = 'SET NAMES utf8mb4'
8 m/ D% i. b' mcharacter-set-server = utf8mb4: h" Y8 P, ], G [# {, Y
innodb_file_format = Barracuda
5 C; v, ?7 R& o! N( ninnodb_file_format_check = ON
7 n( Q1 }8 K# D: f) qinnodb_file_format_max = Barracuda
* ?: n) L0 D1 i1 A& F: g% k" ginnodb_large_prefix = ON
- e6 F+ U* F8 I& F& a6 h[mysql.server]' O5 j+ B- }* E2 Q7 {; G. g
innodb_file_format = Barracuda
( `6 b1 g, Y. hinnodb_file_format_check = ON( _4 j- o0 y- }$ J& p
innodb_file_format_max = Barracuda
* T! D& s W2 T, P4 L4 }- J( a+ Xinnodb_large_prefix = ON4 _' G: R1 a! ?1 i# X
default-character-set = utf8mb4! v! Y% s# J" J6 p! T4 i0 b8 z- M# J
character_set_server = utf8mb4, d2 g# |" [. F3 j, J
[client]6 Y6 {# T# Q$ B* b; G
default-character-set = utf8mb4
1 u( w8 J# Z* W7 |8 t4 b) w1 l5 ]1 ?[mysqld_safe]* Y {! M/ z$ J7 z1 u
default-character-set = utf8mb4- p! b: s5 j4 `+ I3 E; p( u" V
* _8 a( L$ _6 X+ P# S
|
|
发表于 2022-10-26 10:00:33