首先查看编码
show variables like "character%";
Varable_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 | utf8mb4 |
character_set_system | utf8 |
character_sets_dir | F:\tools\phpstudy_pro\Extensions\MySQL5.7.26\share\charsets| |
正确
导出指定编码
mysqldump -u root -p123456 --default-character-set=utf8mb4 game > game.20240130.sql
经过上面两步,导出中文还是乱码
灵机一动,是不是控制台字符集的问题,我是在phpstrom中的terminal中操作,使用的是powershell,换成了CMD后,正常了