From owner-freebsd-isp@FreeBSD.ORG Tue Jul 12 22:29:50 2005 Return-Path: X-Original-To: freebsd-isp@freebsd.org Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 6897816A41C for ; Tue, 12 Jul 2005 22:29:50 +0000 (GMT) (envelope-from gbaratto@superb.net) Received: from pd3mo2so.prod.shaw.ca (shawidc-mo1.cg.shawcable.net [24.71.223.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id 08BDE43D49 for ; Tue, 12 Jul 2005 22:29:49 +0000 (GMT) (envelope-from gbaratto@superb.net) Received: from pd4mr3so.prod.shaw.ca (pd4mr3so-qfe3.prod.shaw.ca [10.0.141.214]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0IJJ00GX2D3S8BB0@l-daemon> for freebsd-isp@freebsd.org; Tue, 12 Jul 2005 16:28:40 -0600 (MDT) Received: from pn2ml7so.prod.shaw.ca ([10.0.121.151]) by pd4mr3so.prod.shaw.ca (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0IJJ00393D3SM2D0@pd4mr3so.prod.shaw.ca> for freebsd-isp@freebsd.org; Tue, 12 Jul 2005 16:28:40 -0600 (MDT) Received: from garrincha (S010600e000eb626b.vc.shawcable.net [24.82.174.10]) by l-daemon (iPlanet Messaging Server 5.2 HotFix 1.18 (built Jul 28 2003)) with SMTP id <0IJJ00G13D3SQM@l-daemon> for freebsd-isp@freebsd.org; Tue, 12 Jul 2005 16:28:40 -0600 (MDT) Date: Tue, 12 Jul 2005 15:28:32 -0700 From: "Gustavo A. Baratto" To: RC , freebsd-isp@freebsd.org Message-id: <018801c58731$0929f8a0$0aae5218@garrincha> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-Mailer: Microsoft Outlook Express 6.00.2900.2527 Content-type: text/plain; reply-type=original; charset=iso-8859-1; format=flowed Content-transfer-encoding: 7bit X-Priority: 3 X-MSMail-priority: Normal References: <20050712214555.42683.qmail@web53902.mail.yahoo.com> Cc: Subject: Re: fastest way to duplicate production server? X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 12 Jul 2005 22:29:50 -0000 - install the new versions of Apache/MySQL/PHP in the test server - make sure apache and php are running with the same configuration of the production server (check httpd.conf, php.ini, etc). Just install mysql, no need to configure it now, as you gonna copy over the configuration and grant tables later. - use rsync to copy the html and php files from the production server to test server. - to copy over mysql data, you must do a " FLUSH TABLES WITH READ LOCK" then rsync the data directory over to the test server (/var/db/mysql is the freebsd default). Then you "UNLOCK TABLES" after rsync is done. Start mysql and you are done. Instead of a "flush tables with read lock", you could just stop mysql in the production server. This is just to make sure there is no updates in the tables while you are copying them over. Cheers ----- Original Message ----- From: "RC" To: Sent: Tuesday, July 12, 2005 2:45 PM Subject: fastest way to duplicate production server? > We have a production FreeBSD 4.10 server running old versions of > Apache/MySQL/PHP from ports. We'd like to upgrade Apache/MySQL/PHP > to the latest versions. Before upgrading we'd like to test on a > test box. > > What's the fastest way of duplicating the existing Apache/MySQL/PHP > (including user databases)? (The production server cannot go down > for more than a few seconds.) > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > _______________________________________________ > freebsd-isp@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org" >