您的位置: 首页 > 技术问答 > MYSQL DBDump错误消息

MYSQL DBDump错误消息

分类: 技术问答 • 2022-05-24 23:59:34

问题描述：

我需要一个DBDUMP，我正在使用MySQL. 当我尝试获取数据库转储时，出现以下错误.任何提示它做错了什么.

I need to get a DBDUMP, i am using MySQL. I get the following error when i try to get a DB Dump. Any clue what it did wrong.

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqldump -u root -p xxx myDB
e >  dump.sql
Enter password: ***
mysqldump: Got error: 1049: Unknown database 'xxx' when selecting the database

答

该命令表示您要在提示符下输入密码，并从xxx数据库中转储myDB表.如果您删除了"xxx"部分并在提示符下输入密码，它应该可以使用.

That command is saying you want to enter the password at the prompt and dump the myDB table from the xxx database. If you get rid of the "xxx" part and enter the password at the prompt, it should work.

如果您实际上要在命令行上指定密码，则必须执行-pWHATEVER(其中"WHATEVER"是文字密码，在切换后没有空格)，或--password=WHATEVER，但是:>

If you actually want to specify the password on the command line, you have to do -pWHATEVER (where "WHATEVER" is the literal password, with no space after the switch), or --password=WHATEVER, but:

在命令行上指定密码应该被认为是不安全的.

Specifying a password on the command line should be considered insecure.