在网上搜索了几个小时后，我发现我没有在Ubuntu软件中心寻找简单的工具。 以下是我找到的一个免费解决方案: http://torasql.com/ 他们声称也有Windows版本，但我只在Ubuntu下使用。

编辑:2015 - 2月- 05 如果你需要Windows工具，TOAD是完美的和免费的: http://software.dell.com/products/toad-for-mysql/

用于MySQL的Toad具有数据和模式比较功能，我相信它甚至可以创建同步脚本。最重要的是，它是免费的。

我正在与Nob Hill的营销团队合作，我想告诉你，我很高兴听到你的问题，建议或其他任何东西，请随时与我联系。

We originally decided to create our tool from scratch because while there are other such products on the market, none of them do the job right. It’s quite easy to show you the differences between databases. It’s quite another to actually make one database like the other. Smooth migration, both of schema and data, has always been a challenge. Well, we have achieved it here. We are so confident that it could provide you a smooth migration, than if it doesn’t – if the migration scripts it generates are not readable enough or won’t work for you, and we can’t fix it in five business days – you will get your own free copy!

http://www.nobhillsoft.com/NHDBCompare.aspx

我认为MySQL的Navicat对这种情况会有帮助。它支持MySQL的数据和结构同步。

如果您正在使用小型数据库，我发现在两个数据库上运行mysqldump，使用——skip-comments和——skip-extended-insert选项生成SQL脚本，那么在SQL脚本上运行diff效果非常好。

By skipping comments you avoid meaningless differences such as the time you ran the mysqldump command. By using the --skip-extended-insert command you ensure each row is inserted with its own insert statement. This eliminates the situation where a single new or modified record can cause a chain reaction in all future insert statements. Running with these options produces larger dumps with no comments so this is probably not something you want to do in production use but for development it should be fine. I've put examples of the commands I use below:

mysqldump --skip-comments --skip-extended-insert -u root -p dbName1>file1.sql
mysqldump --skip-comments --skip-extended-insert -u root -p dbName2>file2.sql
diff file1.sql file2.sql

看一下MySQL的dbForge数据比较。这是一个共享软件，有30天的免费试用期。它是一个快速的MySQL GUI工具，用于数据比较和同步、数据差异管理和可定制的同步。