数据库 MySQL 数据库导入错误:ERROR 1115 (42000): Unknown character set: 'utf8mb4'

sec · January 11, 2017 · Last by sec replied at January 11, 2017 · 16577 hits

由于 linux 中安装的 mysql 默认为 utf8, 将 sql 文件导入 Mysql 出现错误,怎么解决导入错误?

MySQL数据库导入错误:
ERROR 1115 (42000): Unknown character set: 'utf8mb4'
ERROR 1273 (HY000): Unknown collation: 'utf8mb4_unicode_520_ci'
通过sed s/utf8mb4/utf8/g database.sql > database.sed.sql方法, 解决ERROR 1115 (42000): Unknown character set: 'utf8mb4' 

出现导入错误,有没有解决思路?

ERROR 1273 (HY000): Unknown collation: 'utf8mb4_unicode_520_ci'  
ERROR 1146 (42S02): Table 'usc.comments' doesn't exist 

解决思路,Google 错误信息!

回到正题:

确定 MySQL 版本是多少,低于 5.5.3 的没有 utf8mb4 的编码,请升级

http://stackoverflow.com/questions/21911733/error-1115-42000-unknown-character-set-utf8mb4

#2 楼 @huacnlee 服务器 MySQL 5.1.73, 服务器数据库暂时不能升级,使用修改本地服务器数编码

MySQL 5.1.73
mysql> show variables like 'collation%';
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | utf8_general_ci   |
| collation_database   | latin1_swedish_ci |
| collation_server     | latin1_swedish_ci |
+----------------------+-------------------+
sec closed this topic. 11 Jan 15:00
You need to Sign in before reply, if you don't have an account, please Sign up first.