50,639
社区成员
发帖
与我相关
我的任务
分享mysql 导入sql文件报Errors 并出现乱码，以下‘*’代替乱码
09:35:49 Restoring C:\Users\Administrator\Desktop\201508110331.sql
Running: mysql.exe --defaults-file="c:\users\admini~1\appdata\local\temp\tmpzsnyda.cnf" --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=omniv4 < "C:\\Users\\Administrator\\Desktop\\201508110331.sql"
'C:\RECYCLER\yflw.exe' ********************************************************************************************ERROR 1115 (42000) at line 22: Unknown character set: 'utf8mb4'
Operation failed with exitcode 1
09:35:51 Import of C:\Users\Administrator\Desktop\201508110331.sql has finished with 1 errors
Running: mysql.exe --defaults-file="c:\users\admini~1\appdata\local\temp\tmpzsnyda.cnf" --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=omniv4 < "C:\\Users\\Administrator\\Desktop\\201508110331.sql"
'C:\RECYCLER\yflw.exe' ********************************************************************************************ERROR 1115 (42000) at line 22: Unknown character set: 'utf8mb4'
Operation failed with exitcode 1
09:35:51 Import of C:\Users\Administrator\Desktop\201508110331.sql has finished with 1 errors
...全文
请发表友善的回复…
发表回复
迷林 2015-09-17
- 打赏
- 举报
我们项目用的全是utf8的 不能改
baidu_31006959 2015-09-16
- 打赏
- 举报
1. use database_name;
2. set names gbk;
3. source example.sql (sql文件存放路径)
baidu_31006959 2015-09-16
- 打赏
- 举报
设置编码为gbk试下
