If replication is not available, you can use the binary logs (which record all operationso n the database) on one machine and run them on the second machine whenever you want to sync the instances.
Again, you might be needing access to certain configuration files. If this option is irrelevant, then you might need to fall back to other methods which are much less reliable.
发布评论
评论（2）
试试这个：
MySQL 比较
Try this one:
MySQL Compare
如果您希望持续保持数据库实例同步 - 您应该使用正确的主从配置作为您的数据库环境。
查看 http://dev.mysql.com/doc/refman/ 5.5/en/replication.html 了解有关复制的更多信息。
如果复制不可用，您可以使用一台计算机上的二进制日志（记录数据库上的所有操作），并在需要同步实例时在第二台计算机上运行它们。
查看 http://dev.mysql.com/doc/ refman/5.5/en/binary-log.html
同样，您可能需要访问某些配置文件。如果此选项无关紧要，那么您可能需要使用其他不太可靠的方法。
If you want to continuously keep your DB instances synced - you should use a proper master-slave configuration as your DB landscape.
Check out http://dev.mysql.com/doc/refman/5.5/en/replication.html for more info on replication.
If replication is not available, you can use the binary logs (which record all operationso n the database) on one machine and run them on the second machine whenever you want to sync the instances.
Check out http://dev.mysql.com/doc/refman/5.5/en/binary-log.html
Again, you might be needing access to certain configuration files. If this option is irrelevant, then you might need to fall back to other methods which are much less reliable.