Home > Database > Mysql Tutorial > body text

MySQL导入文件报错并且乱码_MySQL

WBOY
Release: 2016-06-01 13:14:49
Original
1194 people have browsed it

实施从客户那里导出数据库给我,我在本机用sqlyog 导入时出现乱码并报错。报错内容为no selected database。但是我数据库确实选择了。

最后问实施的哥们,他说他用sqlyog导出的时候也报错,所以它用Navicat for MySQL。我最后也下载了一个Navicat for MySQL并安装后就好了。花了我好几个小时去找错,因为之前几个库都是没问题的。

下面是错误截图:

/

顺便报个料,下面是我们实际数据库的编码设置:

/

连接MySQL的语句:

      jdbc:mysql://127.0.0.1:3306/db?useUnicode=true&characterEncoding=gbk&autoReconnect=true
Copy after login
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template