如何使用命令行实用程序从MySQL中的远程服务器获取数据库备份脚本？

[英]how to get DB backup script from Remote Server in MySQL using command-line utility?

本文翻译自 Shreekumar S 查看原文 2012/06/01 5424 database/ command-line/ database-scripts/ mysql

Can anybody tell me that how to get DB backup script from Remote Server in MySQL using command-line utility?

谁能告诉我如何使用命令行实用程序从MySQL中的远程服务器获取数据库备份脚本?

I'm using a command as follows, but not working:

我正在使用如下命令,但不能正常工作:

C:\>mysqldump -h <server ip> -u <user-id> -p <password> <db name> >
 E:\dumpfilename.sql

1 个解决方案

#1

The syntax for the password is wrong. You need to write the password immediately after the -p, without a space. That's why the password is interpreted as the database name.

密码的语法错误。您需要在-p之后立即写入密码,没有空格。这就是密码被解释为数据库名称的原因。

Write this instead:

写这个:

C:\>mysqldump -h <server ip> -u <user-id> -p<password> <db name> >
 E:\dumpfilename.sql

Notice how there is no space after -p. An example would be -phunter2, where the password is "hunter2".

请注意-p之后没有空格。一个例子是-phunter2,其中密码是“hunter2”。

智能推荐

注意！

本站翻译的文章，版权归属于本站，未经许可禁止转摘，转摘请注明本文地址：http://www.silva-art.net/blog/2012/06/01/b89b0db6d76c721642f7a7f1f041a5bd.html。

猜您在找

从Java运行Python命令行实用程序。 - Running Python command-line utility from Java 显示命令行实用程序的帮助 - Showing help for a command-line utility 如何使用命令行获取mysql服务器信息？ - How to get mysql server info using command line? 在远程服务器上运行命令行 - Running a command line on a remote server 命令行实用程序的OAuth2客户端服务器身份验证 - OAuth2 client server authentication for a command line utility

赞助商链接