From owner-freebsd-questions@FreeBSD.ORG  Thu Nov  6 08:18:30 2008
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 72E371065676
	for <freebsd-questions@freebsd.org>;
	Thu,  6 Nov 2008 08:18:30 +0000 (UTC)
	(envelope-from sebastian.tymkow@gmail.com)
Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190])
	by mx1.freebsd.org (Postfix) with ESMTP id F1EE88FC19
	for <freebsd-questions@freebsd.org>;
	Thu,  6 Nov 2008 08:18:29 +0000 (UTC)
	(envelope-from sebastian.tymkow@gmail.com)
Received: by nf-out-0910.google.com with SMTP id h3so227967nfh.33
	for <freebsd-questions@freebsd.org>;
	Thu, 06 Nov 2008 00:18:28 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:in-reply-to:mime-version:content-type:references;
	bh=X5HvZcjArAoahAcUJSFkiKrO22y3gRsXQHXGchc6B9Y=;
	b=O95FdWxZc+lrCq+7phCa6Evr41qBvHbrX94IQE62PlOc2Z42bEoOQOZyErBLYDNvwb
	OOqnZ2oqGriajNTF1VwtgYReJ5eU9XRk+Je8/uZqMmr9D1pa+uaUJsueFcO48GYcq2hi
	oquuHtQZIR9lvlqac1zVMbgEjFUSQdRDspK9o=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:in-reply-to:mime-version
	:content-type:references;
	b=b9Ae4E87zAntu7pqwEc4jnhAnjGVqwj34/A77QaAX4UzhdAMIUJ2WkL9Ongzx7hFjj
	O5yJ+l3REe/1kx4lJte7Lhj8JRHkn3/w/fI/qQ+DJxtS5Y3RB3tCnICc9+btBAKrUX0U
	fhgVlQsTLlVHI0gzV5QVeJ3xkwqdYjHRU3i1A=
Received: by 10.210.29.11 with SMTP id c11mr1987585ebc.8.1225959508737;
	Thu, 06 Nov 2008 00:18:28 -0800 (PST)
Received: by 10.210.57.20 with HTTP; Thu, 6 Nov 2008 00:18:28 -0800 (PST)
Message-ID: <692660060811060018m7122c5c6k57f22431a2e8cd8@mail.gmail.com>
Date: Thu, 6 Nov 2008 09:18:28 +0100
From: "=?ISO-8859-1?Q?Sebastian_Tymk=F3w?=" <sebastian.tymkow@gmail.com>
To: freebsd-questions@freebsd.org
In-Reply-To: <692660060811031405t334a1a2cq876913d4b801b180@mail.gmail.com>
MIME-Version: 1.0
References: <835F48BA-494E-44A0-8D2B-D9F139AB2125@identry.com>
	<94136a2c0810010201y6d561828lb125419de1613aee@mail.gmail.com>
	<81F44C16-59C8-4A44-AE2A-B9F233834383@identry.com>
	<692660060810010933t6ada2c85g18b3e0e60d2cf02d@mail.gmail.com>
	<48E484B6.7090502@infracaninophile.co.uk>
	<692660060811031405t334a1a2cq876913d4b801b180@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Content-Filtered-By: Mailman/MimeDel 2.1.5
Subject: Re: Best way to back up mysql database
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 06 Nov 2008 08:18:30 -0000

Hello,

Yes you're right but what I meant was something like this ;))
http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup-and-replication-setup/
It's simple, safe and faster than mysqldump.
On 3 GB database it takes only 3-5 seconds.


Best regards,

Sebastian Tymkow