博主寻求一种方案，每天结束时通过Windows计划任务更新远程Debian服务器上的MySQL数据库。已经创建了远程测试数据库并启用了远程访问。建议考虑使用MySQL的复制功能，无需特定应用，查阅官方文档http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html以实现数据库的比较和同步。
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.
the local database is on a windows machine and remote database is on a webserver with debian.
解决方案
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
扫一扫
1422
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
