Syncronization

2001-04-18 Thread Andrew Dennison
Here's the situation. I have two application servers, each running their own mysql databases. If one goes down, the other takes over for it. But when it comes back up, whatever user preferences were stored on the other server during the downtime are lost. I need a way to syncronize the databas

merging databases

2001-02-01 Thread Andrew Dennison
What would be the best way to take two separate databases, and merge them together into a third database? From the discussions i've read, it seems that dumping them both, then importing them to this new database might be a way of doing it, but is a good way? will it work? Can you suggest a bett