471,108 Members | 1,254 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

Incremental Sync of Two Db's

I have two db's. One on a local server, one on a remote server. Both
are running MySQL 4.0. The remote is a production server that I run
mysqldump on nightly to backup the prod data. The local server db was
created with one of the production dump files, but I'd like to
automatically update my local server with the production data on a
nightly basis.

How can I sync them up? Keep in mind that it's a one way street,
meaning, I cannot make remote connections to the remote db from the
local db. I can however make connections from the remote db to my
local db.

Thanks for any and all suggestions.

Jul 20 '05 #1
0 1485

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by steve | last post: by
reply views Thread by JG | last post: by
3 posts views Thread by Peter Postlbauer | last post: by
3 posts views Thread by mp | last post: by
5 posts views Thread by Joel Matthew | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.