读书人

小弟我在导入数据的时候mysql -uroo

发布时间: 2012-02-17 17:50:42 作者: rapoo

我在导入数据的时候,mysql -uroot -proyasoft mccdb <d:/mccdb/mccdb_0519.sql,出现以下信息!
D:\ROYASOFT\MCC\MySQL\MySQL Server 4.1\bin> mysql -uroot -proyasoft mccdb <d:/mcc
db/mccdb_0519.sql;
mysql Ver 14.7 Distrib 4.1.15, for Win32 (ia32)Copyright (C) 2002 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Usage: mysql [OPTIONS] [database]
-?, --help Display this help and exit.
-I, --help Synonym for -?
--auto-rehash Enable automatic rehashing. One doesn 't need to use
'rehash ' to get table and field completion, but startup
and reconnecting may take a longer time. Disable with
--disable-auto-rehash.
-A, --no-auto-rehash
No automatic rehashing. One has to use 'rehash ' to get
table and field completion. This gives a quicker start of
mysql and disables rehashing on reconnect. WARNING:
options deprecated; use --disable-auto-rehash instead.
-B, --batch Don 't use history file. Disable interactive behavior.
(Enables --silent)
--character-sets-dir=name
Directory where character sets are.
--default-character-set=name
Set the default character set.


-C, --compress Use compression in server/client protocol.
-#, --debug[=#] This is a non-debug version. Catch this and exit
-D, --database=name Database to use.

[解决办法]
命令格式错误吧.mysql -uroot -p
[解决办法]
把你最后的那个分号去掉!

D:\ROYASOFT\MCC\MySQL\MySQL Server 4.1\bin> mysql -uroot -proyasoft mccdb <d:/mcc
db/mccdb_0519.sql;


[解决办法]
这样看下:mysql -uroot -proyasoft mccdb <d:\\mccdb\\mccdb_0519.sql;
royasoft这是你的密码吧

[解决办法]
把分号去掉就可以了!!!! 因为你现在不是在交互平台,所以不能用分号表示

读书人网 >Mysql

热点推荐