每天将本地Microsoft MySQL数据库同步到远程MySQL数据库 [英] Sync Local Microsoft MySQL database to remote mysql database scheduled daily

问题描述

我有一个本地mysql数据库，每天在Windows计算机上进行本地更新.在一天结束时，我希望由Windows调用计划的作业，以便使用所有新数据(即比较和同步)来更新远程mysql数据库.

Hi i have a local mysql database that gets updated locally daily on windows machine. at the end of the day, i want a scheduled job to be called by windows that updates a remote mysql database with all the the new data ie compare and synchronize.

我已经在远程服务器上创建了测试数据库，并且允许远程访问.我想要一个可以在命令行上调用的简单程序/解决方案，用新的或更改的记录等更新远程数据库.

i have already created the test database on remote server and ive allowed remote access. i want simple program/solution that i could call on command line that updates remote database with new or changed records etc.

本地数据库位于Windows计算机上，远程数据库位于具有debian的Web服务器上.

the local database is on a windows machine and remote database is on a webserver with debian.

推荐答案

MySQL允许复制:查看

MySQL allows replication: you wouldnt need to use a specific app, have you looked at http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html

这篇关于每天将本地Microsoft MySQL数据库同步到远程MySQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！