blocks|key|432884|text|在mysql的最新版本中，至少在我的版本中，您不能直接将pass放在命令中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|432885|你必须运行：|432886|mysqldump+-u+[uname]+-p+db_name+>+db_backup.sql|offset|length|style|CODE|432887|然后它会要求你输入密码。|432888|entityMap^0|0|0|0|1B|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@$F|Q|G|R|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

In latest versions of mysql, at least in mine, you cannot put your pass in the command directly.

You have to run:

<code>mysqldump -u [uname] -p db_name &gt; db_backup.sql</code>

and then it will ask for the password.

blocks|key|432860|text|如果从远程服务器下载，这里有一个简单的示例：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|432861|mysqldump+-h+my.address.amazonaws.com+-u+my_username+-p+db_name+>+/home/username/db_backup_name.sql|code-block|syntax|javascript|432862|-p指示您将输入密码，它与db_name无关。输入命令后，系统将提示您输入密码。键入并按enter键。|432863|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

If downloading from remote server, here is a simple example:

<pre><code>mysqldump -h my.address.amazonaws.com -u my_username -p db_name &gt; /home/username/db_backup_name.sql
</code></pre>

The -p indicates you will enter a password, it does not relate to the db_name. After entering the command you will be prompted for the password. Type it in and press enter.

blocks|key|432841|text|在windows上，您需要指定mysqldump.exe所在的mysql。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|432842|cd+C:\xampp\mysql\bin

mysqldump+-u[username]+-p[password]+--all-databases+>+C:\localhost.sql|code-block|syntax|javascript|432843|将其保存到文本文件中，如backup.cmd|432844|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

On windows you need to specify the mysql bin where the mysqldump.exe resides.

<pre><code>cd C:\xampp\mysql\bin

mysqldump -u[username] -p[password] --all-databases &gt; C:\localhost.sql
</code></pre>

save this into a text file such as backup.cmd

blocks|key|432903|text|转到MySQL安装目录并从那里打开cmd。然后执行下面的命令来备份您的数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|432904|mysqldump+-u+root+-p+--add-drop-database+--databases+db>+C:\db-dontdelete\db.sql|code-block|syntax|javascript|432905|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Go to MySQL installation directory and open cmd from there.
Then execute the below command to get a backup of your database.

<pre><code>mysqldump -u root -p --add-drop-database --databases db&gt; C:\db-dontdelete\db.sql
</code></pre>

blocks|key|432820|text|如果您运行的是MySQL而不是默认端口：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|432821|mysqldump.exe+-u+username+-p+-P+PORT_NO+database+>+backup.sql|code-block|syntax|javascript|432822|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you are running the MySQL other than default port:

<pre><code>mysqldump.exe -u username -p -P PORT_NO database &gt; backup.sql
</code></pre>

blocks|key|432982|text|适用于那些想要在命令行中键入密码的用户。这是可能的，但建议在引号中传递它，以便特殊字符不会引起任何问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|432983|mysqldump+-h'my.address.amazonaws.com'+-u'my_username'+-p'password'+db_name+>+/path/backupname.sql|code-block|syntax|javascript|432984|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For those who wants to type password within the command line. It is possible but recommend to pass it inside quotes so that the special character won't cause any issue.

<pre><code>mysqldump -h'my.address.amazonaws.com' -u'my_username' -p'password' db_name &gt; /path/backupname.sql
</code></pre>

blocks|key|214763|text|对于某些版本的MySQL，请尝试。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|214764|sudo+mysqldump+[database+name]+>+db_backup.sql|code-block|syntax|javascript|214765|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For some versions of MySQL try.
<pre><code>sudo mysqldump [database name] &gt; db_backup.sql
</code></pre>

blocks|key|432935|text|如果您有名为archiedb的数据库，请使用以下命令：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|432936|mysql+-p+<password+for+the+database>+--databases+archiedb+>+/home/database_backup.sql|code-block|syntax|javascript|432937|假设这是Linux，请选择备份文件的保存位置。|432938|entityMap^0|6|8|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

If you have the database named <code>archiedb</code>, use this:
<pre><code>mysql -p &lt;password for the database&gt; --databases archiedb &gt; /home/database_backup.sql
</code></pre>
Assuming this is Linux, choose where the backup file will be saved.

blocks|key|432958|text|对于Windows用户，您可以转到mysql文件夹来运行命令|type|unstyled|depth|inlineStyleRanges|entityRanges|data|432959|例如：|432960|cd+c:\wamp64\bin\mysql\mysql5.7.26\bin
mysqldump+-u+root+-p+databasename+>+dbname_dump.sql|code-block|syntax|javascript|432961|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

For Windows users you can go to your mysql folder to run the command

e.g. 

<pre><code>cd c:\wamp64\bin\mysql\mysql5.7.26\bin
mysqldump -u root -p databasename &gt; dbname_dump.sql
</code></pre>

blocks|key|214730|text|注意:此步骤仅在转储MySQL文件之后执行(上面的大多数答案已经解决了这个问题)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|214731|它假设您的远程服务器中有上述转储文件，现在您希望将其下载到本地计算机。|214732|要将转储的.sql文件从远程服务器下载到本地计算机，请执行以下操作|offset|length|style|CODE|214733|scp+-i+YOUR_SSH_KEY+your_username@IP:name_of_file.sql+./my_local_project_dir|code-block|syntax|javascript|214734|entityMap^0|0|0|5|4|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@$F|T|G|U|H|I]]|9|@]|A|$]]|$1|J|3|K|5|L|7|V|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Note: This step only comes after dumping your MySQL file(which most of the answers above have addressed). 

It assumes that you have the said dump file in your remote server and now you want to bring it down to your local computer.

To download the dumped <code>.sql</code> file from your remote server to your local computer, do

<pre><code>scp -i YOUR_SSH_KEY your_username@IP:name_of_file.sql ./my_local_project_dir
</code></pre>

blocks|key|214736|text|@echo+off
for+/f+"tokens=2+delims=="+%25%25a+in+('wmic+OS+Get+localdatetime+/value')+do+set+"dt=%25%25a"
set+"YY=%25dt:~2,2%25"+&+set+"YYYY=%25dt:~0,4%25"+&+set+"MM=%25dt:~4,2%25"+&+set+"DD=%25dt:~6,2%25"
set+"HH=%25dt:~8,2%25"+&+set+"Min=%25dt:~10,2%25"+&+set+"Sec=%25dt:~12,2%25"
set+"datestamp=%25YYYY%25.%25MM%25.%25DD%25.%25HH%25.%25Min%25.%25Sec%25"
set+drive=your+backup+folder
set+databaseName=your+databasename
set+user="your+database+user"
set+password="your+database+password"
subst+Z:+"C:\Program+Files\7-Zip"+
subst+M:+"D:\AppServ\MySQL\bin"
set+zipFile="%25drive%25\%25databaseName%25-%25datestamp%25.zip"
set+sqlFile="%25drive%25\%25databaseName%25-%25datestamp%25.sql"
M:\mysqldump.exe+--user=%25user%25+--password=%25password%25+--result-file="%25sqlFile%25"+--databases+%25databaseName%25
@echo+Mysql+Backup+Created
Z:\7z.exe+a+-tzip+"%25zipFile%25"+"%25sqlFile%25"
@echo+File+Compress+End
del+%25sqlFile%25
@echo+Delete+mysql+file
pause;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|214737|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>@echo off
for /f &quot;tokens=2 delims==&quot; %%a in ('wmic OS Get localdatetime /value') do set &quot;dt=%%a&quot;
set &quot;YY=%dt:~2,2%&quot; &amp; set &quot;YYYY=%dt:~0,4%&quot; &amp; set &quot;MM=%dt:~4,2%&quot; &amp; set &quot;DD=%dt:~6,2%&quot;
set &quot;HH=%dt:~8,2%&quot; &amp; set &quot;Min=%dt:~10,2%&quot; &amp; set &quot;Sec=%dt:~12,2%&quot;
set &quot;datestamp=%YYYY%.%MM%.%DD%.%HH%.%Min%.%Sec%&quot;
set drive=your backup folder
set databaseName=your databasename
set user=&quot;your database user&quot;
set password=&quot;your database password&quot;
subst Z: &quot;C:\Program Files\7-Zip&quot; 
subst M: &quot;D:\AppServ\MySQL\bin&quot;
set zipFile=&quot;%drive%\%databaseName%-%datestamp%.zip&quot;
set sqlFile=&quot;%drive%\%databaseName%-%datestamp%.sql&quot;
M:\mysqldump.exe --user=%user% --password=%password% --result-file=&quot;%sqlFile%&quot; --databases %databaseName%
@echo Mysql Backup Created
Z:\7z.exe a -tzip &quot;%zipFile%&quot; &quot;%sqlFile%&quot;
@echo File Compress End
del %sqlFile%
@echo Delete mysql file
pause;
</code></pre>

I am moving away from Linode because I don't have the Linux sysadmin skills necessary; before I complete the transition to a more noob-friendly service, I need to download the contents of a MySQL database. Is there a way I can do this from the command line?

Downloading MySQL dump from command line

SQL数据库

数据库

服务器

Windows

MySQL

Linux

我离开Linode是因为我不具备必要的Linux sysadmin技能；在完成向对noob更友好的服务的过渡之前，我需要下载一个MySQL数据库的内容。有没有一种方法可以从命令行执行此操作？

问从命令行下载MySQL转储
EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从命令行下载MySQL转储EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从命令行下载MySQL转储
EN