Hello all, Thanks Quinn, your method is essentially what I am currenlty doing, except I'm not using ssh, as the transfers all take place on the local lan and are not visible to the public, so security is not a problem.
So the general consensus is that in terms of qmail the dump is the preferred method? Given that's what I know I don't mind. Thanks for the responses, Erik I will read through that link so at least I know what is involved. The backup server will only import the vpopmail database when data has changed using my current script, and it seems to work quite well. Are there any concerns running a dump on the primary server every few minutes? thanks again. Craig -----Original Message----- From: Quinn Comendant [mailto:[EMAIL PROTECTED] Sent: 09 October 2006 17:47 To: [email protected] Subject: Re: [qmailtoaster] MYSQL help Hi Craig I've tried setting up replication before but was frightened by its complexity. I might suggest just using mysqldump. The vpopmail table should not be updated that frequently (only when accounts are added/edited/deleted), is probably not too large (how many users?), and your second server is not live. So copying the vpopmail table every ten minutes or so should be fine. You can run a command to pull the data across from the second server over a ssh tunnel: ssh -C [EMAIL PROTECTED] "mysqldump --databases -u USERNAME -pPASSWORD vpopmail" | mysql -u -pPASSWORD; Quinn On Mon, 9 Oct 2006 15:33:41 +0100, Craig Smith wrote: > How do I go about configuring mysql to specifically replicate the vpopmail > database to my backup server so that the backup > server always has an up to date copy of the mysql database? > > I can manage without that, but I think it would be more efficient method. --------------------------------------------------------------------- QmailToaster hosted by: VR Hosted <http://www.vr.org> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- QmailToaster hosted by: VR Hosted <http://www.vr.org> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
