Home > Database > Mysql Tutorial > body text

mysql解决导入数据库出现ERROR: Unknown command

WBOY
Release: 2016-06-07 17:52:39
Original
1926 people have browsed it

出现这种情况一般是我们使用了命令模式导入或phpmyadmin导入数据时出现ERROR: Unknown command ,下面我百度了一些解决办法。

解决办法

 代码如下 复制代码

mysqldump -u root -proot –default-character-set=gbk o135 > e:/o135


其它办法

source 命令

mysql>use 数据库

然后使用source命令,后面参数为脚本文件(如这里用到的.sql)

 代码如下 复制代码

mysql>source d:wcnc_db.sql

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