工作和家庭计算机上的 Mysql 同步
我有两个 Windows 7 系统，位于两个不同的位置 - 工作地点和家庭地点，XAMPP 都在它们上运行。我希望能够同步位于机器上的 mysql 数据库。问题是两台机器都不能持续连接到互联网，并且没有专用 IP。
我想到使用一些云托管服务来共享mysql中的“data”文件夹。但由于某种原因，数据库的表没有显示在系统 #2 中，认为它说 DB(3) - 3 是数据库中表的数量。在这种情况下，我没有同步整个数据文件夹，而是同步特定数据库的文件夹。不确定这是否是一种方法。
有没有更好的方法来同步两个数据库。请注意，我只在两台机器上工作，并且一次只更新一个位置的数据库。这样就不会出现记录冲突的问题。我只是希望两个系统在一天结束时都更新为相同的数据。
I have two Windows 7 systems located in two different locations - work and home, with XAMPP running on both of them. I would like to be able to sync the mysql databases located on the machines. The problem is that both the machines do not stay connnected to the internet continously and do not have dedicated IPs.
I thought of using some cloud hosting service to share the "data" folder in mysql. But for some reason, the tables for the db are not showing up in System #2, thought it said DB(3) - 3 being the number of tables in the database. In this case, i didn't sync the whole of data folder, but the folder of a particular database. Not sure if this is a way of doing it.
Is there a better method of syncing both the databases. Please note that I only work on both the machines and update the database only in one location at a time. So the issue of conflicting records won't occur. I just would like both the systems updated with the same data at the end of the day.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我不知道你的数据库有多大，但你可以使用外部硬盘驱动器作为 MySQL 路径。
I don't know how big your DB is but you could just use an external hard drive as your MySQL path.
根据数据库的大小，DropBox 可能是一个解决方案，因为它镜像了一个可以用作 MySQL 数据的本地目录通往他们的云的路径。尽管将它用于各种同步（包括 Smalltalk 图像），但我从未尝试过将它用作数据库数据目录。
Depending on your DB's sizes probably DropBox can be a solution because it mirrors a local directory which may serve as your MySQL data path to their cloud. Although using it for all kinds of snychronisation (including Smalltalk images) I never tried using it as a DB data directory.