From owner-freebsd-questions@FreeBSD.ORG Tue Oct 18 08:15:51 2005 Return-Path: X-Original-To: questions@freebsd.org Delivered-To: freebsd-questions@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 6F65A16A423 for ; Tue, 18 Oct 2005 08:15:51 +0000 (GMT) (envelope-from nicklas@dinpris.no) Received: from dp-mail-01.dinpris.com (dp-mail-01.dinpris.com [62.73.247.20]) by mx1.FreeBSD.org (Postfix) with SMTP id 142A043D69 for ; Tue, 18 Oct 2005 08:15:44 +0000 (GMT) (envelope-from nicklas@dinpris.no) Received: (qmail 72670 invoked by uid 1004); 18 Oct 2005 08:32:06 -0000 Received: from 62.73.247.155 by dp-mail-01.dinpris.com (envelope-from , uid 98) with qmail-scanner-1.25 (clamdscan: 0.86.2/1137. spamassassin: 3.1.0-rc1. perlscan: 1.25. Clear:RC:1(62.73.247.155):. Processed in 0.051953 secs); 18 Oct 2005 08:32:06 -0000 X-Qmail-Scanner-Mail-From: nicklas@dinpris.no via dp-mail-01.dinpris.com X-Qmail-Scanner: 1.25 (Clear:RC:1(62.73.247.155):. Processed in 0.051953 secs) Received: from 529c-tbg7-5fl.oslo.dinpris.com (HELO ?62.73.247.155?) (nicklas@dinpris.no@62.73.247.155) by dp-mail-01.dinpris.com with SMTP; 18 Oct 2005 08:32:06 -0000 Message-ID: <4354AEF4.9060301@dinpris.no> Date: Tue, 18 Oct 2005 10:14:44 +0200 From: "Nicklas B. Westerlund" User-Agent: Thunderbird 1.4 (Windows/20050908) MIME-Version: 1.0 To: John Oxley References: <20051018074634.GA6287@yoafrica.com> In-Reply-To: <20051018074634.GA6287@yoafrica.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: questions@freebsd.org Subject: Re: MySQL syncing X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 18 Oct 2005 08:15:51 -0000 John Oxley wrote: > Okay, I want to sync two tables in one database from a master box to a > slave. Doing live syncing would be preferable, but not essential (I can > cron it to happen every 5 mins or so). replicate-do-table Look into it ;-) (It'll do exactly what you want, in realtime) N.