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]
