Trying to get a clear picture here... Curtis Maurand wrote: > Hello, > My hoster decided to host my routing between my two machines. dbmail > runs on one machine while the database sits on a second. I managed to > run a restore to a 2nd server for the database and bring the mail server > back up.
So you're back up and running using another database server without data-loss? > Is there a way to grab all the mail posted after a certain time on the > backup server and post it back to the primary machine? You don't want that. Trying to 'diff' two databases to generate a 'patch' that will update one database to match a second one - if I read correctly what you are aiming at - is error-prone, non-trivial, etc. > A set of queries to dump out the needed mail or a method would be > greatly appreciated. Dumping the mail is not sufficient if you provide IMAP. > I gotta get replication set up. :-| Maybe this is a good time. For MySQL I could tell you how, no sweat, using two simple config tweaks, and two queries. The most reliable way to migrate a database from one host to another is a dump-load, but I assume you already know that. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
