blocks|key|3003541|text|我认为这是不可能的，但您可以尝试这些解决方案，您必须键入要转储的所有数据库的名称。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3003542|mysqldump+-u+root+-password+--databases+db1+db2+db3+...+db36+>+mydb_dump.sql|code-block|syntax|javascript|3003543|如果解决办法有帮助，请告诉我。|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|K|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|L|8|@]|9|@]|A|$]]]|I|$]]

I don't think it is possible, but you can try these solution which you will have to type the names of all the databases you want to dump.

<pre><code>mysqldump -u root -password --databases db1 db2 db3 ... db36 &gt; mydb_dump.sql
</code></pre>

Let me know if the solution helps.

blocks|key|1862426|text|即使在这里有这么多优秀的答案，所以这篇文章只是想多加一个选择。在脚本中的2行以下，您可以使用服务器所有DB的备份而忽略一些DB。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1862427|DB_LIST=`mysql+-Nse+"SELECT+GROUP_CONCAT(SCHEMA_NAME+SEPARATOR+'+')+FROM+information_schema.SCHEMATA+WHERE+SCHEMA_NAME+NOT+IN+('mysql','information_schema','performance_schema','sys');"`

mysqldump+-R+-B+$DB_LIST+>+BACKUPNAME.sql|code-block|syntax|javascript|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|I|8|@]|9|@]|A|$E|F]]]|G|$]]

Even here so many excellent answers, so this post is just to add one more choice. By below 2 lines in script, you can take your servers all DB's backup ignoring some DB.

<pre><code>DB_LIST=`mysql -Nse "SELECT GROUP_CONCAT(SCHEMA_NAME SEPARATOR ' ') FROM information_schema.SCHEMATA WHERE SCHEMA_NAME NOT IN ('mysql','information_schema','performance_schema','sys');"`

mysqldump -R -B $DB_LIST &gt; BACKUPNAME.sql
</code></pre>

blocks|key|3004020|text|从MySQL+5.7.8开始，您可以使用mysqlpump+(与mysqldump不一样)如下：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3004021|mysqlpump+--user=user+--password+--exclude-databases=db1,db2,db3,db4 --result-file=partial_backup.sql|code-block|syntax|javascript|3004022|只需将db1,db2,db3,db4替换为您想要排除的四个数据库。|3004023|来源：MySQL服务器博客|entityMap|0|LINK|mutability|MUTABLE|url|https://mysqlserverteam.com/introducing-mysqlpump/^0|K|9|W|9|0|0|3|F|0|3|A|0^^$0|@$1|2|3|4|5|6|7|V|8|@$9|W|A|X|B|C]|$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|10|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|11|8|@$9|12|A|13|B|C]]|D|@]|E|$]]|$1|M|3|N|5|6|7|14|8|@]|D|@$9|15|A|16|1|17]]|E|$]]]|O|$P|$5|Q|R|S|E|$T|U]]]]

Since MySQL 5.7.8, you can use <code>mysqlpump</code> (which is NOT the same as <code>mysqldump</code>) as follows:

<pre><code>mysqlpump --user=user --password --exclude-databases=db1,db2,db3,db4 --result-file=partial_backup.sql
</code></pre>

Just replace <code>db1,db2,db3,db4</code> with the four databases you want to exclude.

Source: <a href="https://mysqlserverteam.com/introducing-mysqlpump/" rel="noreferrer">MySQL Server Blog</a>

blocks|key|3003626|text|或者，您可以查看以下链接；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3003627|Mysqldump忽略数据库选项|offset|length|3003628|++++++++++++OR|code-block|syntax|javascript|3003629|几个模拟mysqldump的黑客--忽略-数据库|3003630|实现mysqldump+-忽略-数据库|3003631|如果解决办法有帮助，请告诉我。|3003632|祝你好运！|entityMap|0|LINK|mutability|MUTABLE|url|http://ronaldbradford.com/blog/i-want-a-mysqldump-ignore-database-option-2012-04-18/|1|http://datacharmer.blogspot.com/2012/04/few-hacks-to-simulate-mysqldump-ignore.html|2|http://www.markleith.co.uk/2012/04/20/implementing-mysqldump-ignore-database/^0|0|0|G|0|0|0|0|O|1|0|0|J|2|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|14|8|@]|9|@$D|15|E|16|1|17]]|A|$]]|$1|F|3|G|5|H|7|18|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|19|8|@]|9|@$D|1A|E|1B|1|1C]]|A|$]]|$1|M|3|N|5|6|7|1D|8|@]|9|@$D|1E|E|1F|1|1G]]|A|$]]|$1|O|3|P|5|6|7|1H|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1I|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y]]|Z|$5|U|V|W|A|$X|10]]|11|$5|U|V|W|A|$X|12]]]]

Alternatively, you can look at the following links;

<a href="http://ronaldbradford.com/blog/i-want-a-mysqldump-ignore-database-option-2012-04-18/" rel="nofollow">Mysqldump Ignore Database Option</a>

<pre><code> OR
</code></pre>

<a href="http://datacharmer.blogspot.com/2012/04/few-hacks-to-simulate-mysqldump-ignore.html" rel="nofollow">A few hacks to simulate mysqldump --ignore-database </a>

<a href="http://www.markleith.co.uk/2012/04/20/implementing-mysqldump-ignore-database/" rel="nofollow">Implementing mysqldump –ignore-database</a>

Let me know if the solution helps.

Goodluck!

blocks|key|1862860|text|许多人一直希望mysqldump忽略数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1862861|你会相信现在存在这种选择吗？不，不是在我的垃圾场。|1862862|甲骨文(Yuck，toowee，仍然没有翻滚舌头)有DataPump+(expdb+)来转储甲骨文数据库。由于Oracle5.7家族中的MySQL+5.7+(仍然很受伤)，新的备份实用程序称为米赛尔泵，它附带了-排除-数据库和其他整洁的选项。和它的哥哥数据泵一样，米赛尔泵也有并行化，以帮助加快转储和分工的功能。在这个时候，我还没有加入到工作中，但看起来很有希望。当我深入研究米赛尔泵时，我可能会发现它带来了与甲骨文的数据泵相同的外观和感觉。|offset|length|1862863|如果在MySQL平行宇宙中有任何关于它的故事，请在这里张贴它。|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_export.htm#g1022624|1|https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html|2|https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html#option_mysqlpump_exclude-databases|3|4|5|https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html#mysqlpump-parallelism|6|7^0|0|0|Q|H|0|2O|4|1|2X|7|2|3I|3|3|3O|4|4|3U|E|5|58|4|6|5T|3|7|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|12|8|@]|9|@$F|13|G|14|1|15]|$F|16|G|17|1|18]|$F|19|G|1A|1|1B]|$F|1C|G|1D|1|1E]|$F|1F|G|1G|1|1H]|$F|1I|G|1J|1|1K]|$F|1L|G|1M|1|1N]|$F|1O|G|1P|1|1Q]]|A|$]]|$1|H|3|I|5|6|7|1R|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P]]|Q|$5|L|M|N|A|$O|R]]|S|$5|L|M|N|A|$O|T]]|U|$5|L|M|N|A|$O|P]]|V|$5|L|M|N|A|$O|R]]|W|$5|L|M|N|A|$O|X]]|Y|$5|L|M|N|A|$O|R]]|Z|$5|L|M|N|A|$O|P]]]]

Many have always wanted mysqldump to ignore databases.

Would you believe that option exists now ??? No, not in mysqldump.

Oracle (Yuck, toowee, still doesn't roll off the tongue) has <a href="https://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_export.htm#g1022624" rel="nofollow noreferrer">DataPump (expdb impdp)</a> to dump Oracle databases. Since MySQL 5.7 in the Oracle family (still hurting), the new backup utility program is called <a href="https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html" rel="nofollow noreferrer">mysqlpump</a>, which comes with <a href="https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html#option_mysqlpump_exclude-databases" rel="nofollow noreferrer">--exclude-databases</a> and other neat options. Like its older stepbrother <a href="https://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_export.htm#g1022624" rel="nofollow noreferrer">datapump</a>, <a href="https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html" rel="nofollow noreferrer">mysqlpump</a> also features <a href="https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html#mysqlpump-parallelism" rel="nofollow noreferrer">parallelism to help speed up dumps and divide work</a>. At this time, I have not incorporated into at the job, but it looks very promising. When I deep dive into <a href="https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html" rel="nofollow noreferrer">mysqlpump</a> I might find that it brings the same look and feel as Oracle's <a href="https://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_export.htm#g1022624" rel="nofollow noreferrer">datapump</a>.

If there is anyone in the MySQL Parallel Universe with stories about it, please post it here.

We have 40 databases in our server. 

We want to take 36 databases backup using mysqldump. How can i ignore remaining 4 databases in mysqldump command? Is there any option for mysqldump to ignore databases for backup in MySQL?

I know the general mysqldump command but it is very lengthy. I want to ignore only 4 databases and need to take remaining dbs backup.

Any option for mysqldump to ignore databases for backup?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我们的服务器上有40个数据库。我们希望使用mysqldump备份36个数据库。如何忽略mysqldump命令中剩下的4个数据库？对于mysqldump是否有任何选项可以忽略MySQL中备份的数据库？我知道一般的mysqldump命令，但是它非常长。我只想忽略4个数据库，需要进行其余的dbs备份。

问mysqldump是否可以忽略用于备份的数据库？
EN

回答 5

Database Administration用户

Database Administration用户

Database Administration用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysqldump是否可以忽略用于备份的数据库？EN

回答 5

Database Administration用户

Database Administration用户

Database Administration用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysqldump是否可以忽略用于备份的数据库？
EN