blocks|key|4840511|text|Navicat可以为您做到这一点。它还将在两个mysql数据库实例之间同步模式和/或数据。在过去，我成功地使用过它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4840512|http://www.navicat.com/en/products/navicat_mysql/mysql_overview.html|offset|length|4840513|这里有一个数据和结构同步工具的截图：|4840514|http://www.navicat.com/en/products/navicat_mysql/mysql_detail_mac.html#7|4840515|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|0|1W|0|0|0|0|20|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@$D|Y|E|Z|1|10]]|A|$]]|$1|J|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|C]]|Q|$5|M|N|O|A|$P|I]]]]

Navicat is able to do that for you. It will also synchronize schema and/or data between two mysql database instances. I've used it with success in the past.

<a href="http://www.navicat.com/en/products/navicat_mysql/mysql_overview.html" rel="noreferrer">http://www.navicat.com/en/products/navicat_mysql/mysql_overview.html</a>

There is a screenshot of the data and structure synchronization tool here:

<a href="http://www.navicat.com/en/products/navicat_mysql/mysql_detail_mac.html#7" rel="noreferrer">http://www.navicat.com/en/products/navicat_mysql/mysql_detail_mac.html#7</a>

blocks|key|1248855|text|可能有点晚了，但我刚刚用PHP语言编写了一个简单的工具来比较MySQL数据库模式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1248856|PHP+script+to+compare+MySQL+database+schemas+How+to+use+the+script|offset|length|1248857|它导出模式并在进行比较之前对其进行序列化。这是为了比较驻留在不同主机上的数据库(+PHP脚本可能无法同时访问这两个主机)。|1248858|编辑：|style|BOLD|1248859|Python+Script|1248860|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/joefreeman/dbdiff|1|https://web.archive.org/web/20160203150852/http://joef.co.uk/blog/2009/07/php-script-to-compare-mysql-database-schemas|2|https://github.com/cj203/compare_mysql/blob/master/schema_diference.py^0|0|0|18|0|19|L|1|0|0|0|3|0|0|D|2|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|10|8|@]|9|@$D|11|E|12|1|13]|$D|14|E|15|1|16]]|A|$]]|$1|F|3|G|5|6|7|17|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|18|8|@$D|19|E|1A|J|K]]|9|@]|A|$]]|$1|L|3|M|5|6|7|1B|8|@]|9|@$D|1C|E|1D|1|1E]]|A|$]]|$1|N|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U]]|V|$5|Q|R|S|A|$T|W]]|X|$5|Q|R|S|A|$T|Y]]]]

Perhaps a bit late to the party, but I've just written a simple tool in PHP to compare MySQL database schemas:

<a href="https://github.com/joefreeman/dbdiff" rel="nofollow noreferrer">PHP script to compare MySQL database schemas</a>
<a href="https://web.archive.org/web/20160203150852/http://joef.co.uk/blog/2009/07/php-script-to-compare-mysql-database-schemas" rel="nofollow noreferrer">How to use the script</a>

It exports the schema and serialises it before doing the comparison. This is so that databases can be compared that reside on different hosts (where both hosts may not be accessible by the PHP script).

Edit:

<a href="https://github.com/cj203/compare_mysql/blob/master/schema_diference.py" rel="nofollow noreferrer">Python Script</a>

blocks|key|1254384|text|我使用SQLyog：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1254385|http://www.webyog.com/en/|offset|length|1254386|它不是免费的，但它是一个非常好的工具，并且已经节省了很多倍的许可证成本。我与该公司没有任何关系，只是一个使用过许多MySQL工具的人。|1254387|可从here获得免费试用(30天)。|1254388|​|1254389|📷|atomic|1254390|1254391|entityMap|0|LINK|mutability|MUTABLE|url|1|http://www.webyog.com/en/downloads.php|2|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/a19bdf4e879527418268579545b4fedc.png|imageAlt^0|0|0|P|0|0|0|2|4|1|0|0|0|1|2|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@]|9|@$D|16|E|17|1|18]]|A|$]]|$1|F|3|G|5|6|7|19|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1A|8|@]|9|@$D|1B|E|1C|1|1D]]|A|$]]|$1|J|3|K|5|6|7|1E|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|1F|8|@]|9|@$D|1G|E|1H|1|1I]]|A|$]]|$1|O|3|K|5|6|7|1J|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|Q|$R|$5|S|T|U|A|$V|C]]|W|$5|S|T|U|A|$V|X]]|Y|$5|Z|T|10|A|$11|12|13|-4]]]]

I use SQLyog:

<a href="http://www.webyog.com/en/" rel="nofollow noreferrer">http://www.webyog.com/en/</a>

It isn't free but is a very good tool and has saved the cost of it's license many many times over. I'm in no way affiliated with the company, just someone who has used a number of MySQL tools.

Free trial(30-day) available from <a href="http://www.webyog.com/en/downloads.php" rel="nofollow noreferrer">here</a>.

<img src="https://i.stack.imgur.com/dCzMA.png" alt="enter image description here">

blocks|key|776285|text|最好的做法是尝试一些已经存在的性能基准测试。使用经过测试的基准测试总是更好的，除非您完全确信您的数据和数据库加载将与传统的使用模式有很大的不同(但是，那么，您使用数据库做什么呢？)。我要偷走my+own+answer+from+ServerFault|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|776286|776287|有很多针对不同MySQL数据库引擎的基准测试。在Percona+MySQL+Performance+++Blog上有一个比较MyISAM，InnoDB和Falcon的不错的例子，参见here。|blockquote|776288|776289|前面提到的两个引擎(MyISAM和InnoDB)之间需要考虑的另一件事是它们的锁定方法。MyISAM执行表锁定，而InnoDB执行行锁定。需要考虑的事情有很多，不仅仅是性能数据。|776290|entityMap|0|LINK|mutability|MUTABLE|url|https://serverfault.com/questions/219/how-do-you-choose-a-mysql-database-engine/232#232|1|http://www.mysqlperformanceblog.com/|2|http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1/^0|2N|U|0|0|0|O|W|1|2J|4|2|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|-4|5|6|7|10|8|@]|9|@]|C|$]]|$1|E|3|F|5|G|7|11|8|@]|9|@$A|12|B|13|1|14]|$A|15|B|16|1|17]]|C|$]]|$1|H|3|-4|5|6|7|18|8|@]|9|@]|C|$]]|$1|I|3|J|5|6|7|19|8|@]|9|@]|C|$]]|$1|K|3|-4|5|6|7|1A|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]|S|$5|N|O|P|C|$Q|T]]|U|$5|N|O|P|C|$Q|V]]]]

The best thing to do is to try out some performance benchmarks that are already out there. It's always better to use tried-and-tested benchmarks, unless you're thoroughly convinced that your data and database loading is going to be significantly different to the traditional usage patterns (but, then, what are you using a database for?). I'm going to steal <a href="https://serverfault.com/questions/219/how-do-you-choose-a-mysql-database-engine/232#232">my own answer from ServerFault</a>:

<blockquote>
 There are a good number of benchmarks
 out there for different MySQL database
 engines. There's a decent one
 comparing MyISAM, InnoDB and Falcon on
 the <a href="http://www.mysqlperformanceblog.com/" rel="nofollow noreferrer">Percona MySQL Performance
 Blog</a>, see <a href="http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1/" rel="nofollow noreferrer">here</a>.
 
 Another thing to consider between the
 two aforementioned engines (MyISAM and
 InnoDB) are their approaches to
 locking. MyISAM performs
 table-locking, whilst InnoDB performs
 row-locking. There are a variety of
 things to consider, not only downright
 performance figures.
</blockquote>

I am looking for a tool that will allow me to compare schemas of MySQL databases. 
 Which is the best tool to do that?

How to compare MySQL database schemas

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

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

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

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

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

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

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

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

社区新版编辑器体验调研

我正在寻找一个工具，可以让我比较MySQL数据库的模式。哪种工具是最好的呢？

问如何比较MySQL数据库架构
EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何比较MySQL数据库架构EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何比较MySQL数据库架构
EN