From owner-freebsd-questions@FreeBSD.ORG Wed Sep 3 20:33:51 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 0272C1065676 for ; Wed, 3 Sep 2008 20:33:51 +0000 (UTC) (envelope-from derekb@realgeeky.com) Received: from austin.tocun.com (www.tocun.com [66.194.163.10]) by mx1.freebsd.org (Postfix) with ESMTP id D25EA8FC26 for ; Wed, 3 Sep 2008 20:33:50 +0000 (UTC) (envelope-from derekb@realgeeky.com) Received: from cpe-74-69-80-201.rochester.res.rr.com ([74.69.80.201] helo=[172.16.1.202]) by austin.tocun.com with esmtpsa (TLS-1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.63) (envelope-from ) id 1KaxwS-0003HN-Ec; Wed, 03 Sep 2008 15:23:08 -0400 Message-Id: <4EC04561-2F39-45B1-9A4E-932A53D6A625@realgeeky.com> From: Derek Belrose To: "Mad Unix" In-Reply-To: <4d3f56c90809031149p77611502t5295ea273dab828e@mail.gmail.com> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v928.1) Date: Wed, 3 Sep 2008 15:22:58 -0400 References: <4d3f56c90809031149p77611502t5295ea273dab828e@mail.gmail.com> X-Mailer: Apple Mail (2.928.1) X-SA-Exim-Connect-IP: 74.69.80.201 X-SA-Exim-Mail-From: derekb@realgeeky.com X-Spam-Checker-Version: SpamAssassin 3.1.7-deb (2006-10-05) on austin.tocun.com X-Spam-Level: X-Spam-Status: No, score=-0.5 required=5.0 tests=ALL_TRUSTED,AWL, SARE_SPEC_REPLICA_OBFU autolearn=no version=3.1.7-deb X-SA-Exim-Version: 4.2.1 (built Tue, 09 Jan 2007 17:23:22 +0000) X-SA-Exim-Scanned: Yes (on austin.tocun.com) Cc: freebsd-questions@freebsd.org Subject: Re: mysql 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: Wed, 03 Sep 2008 20:33:51 -0000 On Sep 3, 2008, at 2:49 PM, Mad Unix wrote: > I need to replicate MySQL DB of mulltiple server on SiteA to my DR- > Site > Site_B... all DB > are alocated on RHEL,SuSE,Centos,Debian, FreeBSD servers. > I need a script to take Multiple MySql DataBase Backup and then > import to > SiteB, the replica > can be done as cold or hotbackup and cron it Do you want replication or to copy the binary databases? You can just copy the databases: shut the server down, copy the database files over using scp. Or, you can set up replication where anytime you write to Site A you write to Site B. The latter is more work to setup but it's near instant replication while the prior is done at a scheduled time. -Derek