From owner-freebsd-isp@FreeBSD.ORG  Wed Jul 13 12:43:46 2005
Return-Path: <owner-freebsd-isp@FreeBSD.ORG>
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 5A9C416A41C
	for <freebsd-isp@freebsd.org>; Wed, 13 Jul 2005 12:43:46 +0000 (GMT)
	(envelope-from wendel@dotpix.com.br)
Received: from d.dotpix.com.br (mx1.dotpix.com.br [201.30.129.132])
	by mx1.FreeBSD.org (Postfix) with ESMTP id E28AE43D48
	for <freebsd-isp@freebsd.org>; Wed, 13 Jul 2005 12:43:45 +0000 (GMT)
	(envelope-from wendel@dotpix.com.br)
Received: from localhost (localhost [127.0.0.1])
	by mx1.dotpix.com.br (Postfix) with ESMTP id 9F43438B881
	for <freebsd-isp@freebsd.org>; Wed, 13 Jul 2005 09:44:05 -0300 (BRST)
Received: from d.dotpix.com.br ([127.0.0.1])
	by localhost (d.dotpix.com.br [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 71206-03 for <freebsd-isp@freebsd.org>;
	Wed, 13 Jul 2005 09:44:04 -0300 (BRST)
Received: from [10.0.0.4] (unknown [201.30.129.190])
	by d.dotpix.com.br (Postfix) with ESMTP id BCE5438B807
	for <freebsd-isp@freebsd.org>; Wed, 13 Jul 2005 09:44:03 -0300 (BRST)
Date: Wed, 13 Jul 2005 09:43:37 -0300
From: wendelmaques <wendel@dotpix.com.br>
To: freebsd-isp@freebsd.org
Message-ID: <ACE54F0BA44E6F08A0CBB2BE@[10.0.0.4]>
In-Reply-To: <018801c58731$0929f8a0$0aae5218@garrincha>
References: <20050712214555.42683.qmail@web53902.mail.yahoo.com>
	<018801c58731$0929f8a0$0aae5218@garrincha>
X-Mailer: Mulberry/3.1.6 (Win32)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Virus-Scanned: by amavisd-new at dotpix.com.br
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 <freebsd-isp.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-isp>
List-Post: <mailto:freebsd-isp@freebsd.org>
List-Help: <mailto:freebsd-isp-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 13 Jul 2005 12:43:46 -0000

> - 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

If mysql version differ, you can use on the database host:

mysqldump -A --all --opt -Q -uroot -p | mysql -uroot -p 
-hdestination.host.net
# you database host            | you remote host
# you must type mysql password twice
# then use mysql_fix_privileges_table

We use it to dump databases from old mysql 3 to 4.

To dump or redump users files, you can use the fast perl rsync script: 
drsync

--
 wendelmaques
 http://www.dotpix.com.br/~wendel/