Paul J Stevens wrote: > > 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?
That is correct. I probably lost about 4.5 hours. I had a backup at 4 am and the routing went away at 8:30. I restored the backup to another backup server on the other side of the country and on another network and started up as a stopgap to get the mail running again. > >> 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. Yeah, I figured. But I was hoping, though. It was thought. If there were timestamps in there somewhere, I figured I could key in on those. > >> 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. Yep, knew that and because of the way that the data was dumped in the first place, I am stuck with dumping the entire database. :-( The way to do it is binary logging and dumping running mysqlbinlog, etc. etc. etc. better-yet, setting up real time replication and then play back the binlog from the time needed. Ah...live and learn. Thanks for your help, Curtis > > -- > ________________________________________________________________ > 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 >
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
