From owner-freebsd-questions@FreeBSD.ORG Thu Oct 2 08:22:27 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 7D5161065686 for ; Thu, 2 Oct 2008 08:22:27 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (gate6.infracaninophile.co.uk [IPv6:2001:8b0:151:1::1]) by mx1.freebsd.org (Postfix) with ESMTP id E21B78FC1C for ; Thu, 2 Oct 2008 08:22:26 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from lack-of-gravitas.thebunker.net (gateway.ash.thebunker.net [213.129.64.4]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.3/8.14.3) with ESMTP id m928MED4068981 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 2 Oct 2008 09:22:20 +0100 (BST) (envelope-from m.seaman@infracaninophile.co.uk) X-DKIM: Sendmail DKIM Filter v2.7.2 smtp.infracaninophile.co.uk m928MED4068981 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=infracaninophile.co.uk; s=200708; t=1222935740; bh=H4mS9Ry/pjvCyA YmZjWt7YbrYwn5zQDhXg444lBSods=; h=Message-ID:Date:From:MIME-Version: To:CC:Subject:References:In-Reply-To:Content-Type: Content-Transfer-Encoding:Cc:Content-Type:Date:From:In-Reply-To: Message-ID:Mime-Version:References:To; z=Message-ID:=20<48E484B6.7 090502@infracaninophile.co.uk>|Date:=20Thu,=2002=20Oct=202008=2009: 22:14=20+0100|From:=20Matthew=20Seaman=20|Organization:=20Infracaninophile|User-Agent:=20Thunderbird= 202.0.0.16=20(X11/20080811)|MIME-Version:=201.0|To:=20=3D?UTF-8?B?U 2ViYXN0aWFuIFR5bWvDs3c=3D?=3D=20|CC:=20 John=20Almberg=20,=20freebsd-questions@freebs d.org|Subject:=20Re:=20Best=20way=20to=20back=20up=20mysql=20databa se|References:=20<835F48BA-494E-44A0-8D2B-D9F139AB2125@identry.com> =09<94136a2c0810010201y6d561828lb125419de1613aee@mail.gmail.com>=09 <81F44C16-59C8-4A44-AE2A-B9F233834383@identry.com>=20<6926600608100 10933t6ada2c85g18b3e0e60d2cf02d@mail.gmail.com>|In-Reply-To:=20<692 660060810010933t6ada2c85g18b3e0e60d2cf02d@mail.gmail.com>|X-Enigmai l-Version:=200.95.6|Content-Type:=20text/plain=3B=20charset=3DUTF-8 =3B=20format=3Dflowed|Content-Transfer-Encoding:=208bit; b=cEs/hf2u POY3rA6wAY+eVdaTGwsATAsEaPs9+rFB08odJ3oWo4Mzi4ox4W6ne7NlIag5tQuU1rc 2ej8xiqyP9JK0qoDNQ8VqwUfgL9eraXPvnbKH1yFx1fSgBAS2y1XEDWVYYETDuoB6TO gLjp9lO3LdhyaVyk0nQo/D4RPILrw= Message-ID: <48E484B6.7090502@infracaninophile.co.uk> Date: Thu, 02 Oct 2008 09:22:14 +0100 From: Matthew Seaman Organization: Infracaninophile User-Agent: Thunderbird 2.0.0.16 (X11/20080811) MIME-Version: 1.0 To: =?UTF-8?B?U2ViYXN0aWFuIFR5bWvDs3c=?= References: <835F48BA-494E-44A0-8D2B-D9F139AB2125@identry.com> <94136a2c0810010201y6d561828lb125419de1613aee@mail.gmail.com> <81F44C16-59C8-4A44-AE2A-B9F233834383@identry.com> <692660060810010933t6ada2c85g18b3e0e60d2cf02d@mail.gmail.com> In-Reply-To: <692660060810010933t6ada2c85g18b3e0e60d2cf02d@mail.gmail.com> X-Enigmail-Version: 0.95.6 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (smtp.infracaninophile.co.uk [81.187.76.162]); Thu, 02 Oct 2008 09:22:20 +0100 (BST) X-Virus-Scanned: ClamAV 0.94/8370/Thu Oct 2 04:51:47 2008 on happy-idiot-talk.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.6 required=5.0 tests=AWL,BAYES_00,DKIM_SIGNED, DKIM_VERIFIED,SPF_FAIL autolearn=no version=3.2.5 X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on happy-idiot-talk.infracaninophile.co.uk Cc: John Almberg , freebsd-questions@freebsd.org 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 02 Oct 2008 08:22:27 -0000 -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 Sebastian Tymków wrote: | Hello, | | You can store whole db files too. It's faster to run database from scratch | than use mysqldump and mysql "source". Um... no. In general you cannot do this, and it is exceedingly irresponsible to suggest such a thing. The *only* way this would ever be workable is if you shut down MySQL completely while your backup process was running. For anything other than a pissant little hobbyist DB that does no real work, that idea is just going to be a non-starter. If MySQL is running, then there is no guarantee that the contents of any disk file has been properly synched with the in-memory working copy of the data. Basically what you'ld be copying off the disk drive will be full of inconsistencies and hence useless as a backup. This is why programs like mysqldump(1) exist. Cheers, Matthew - -- Dr Matthew J Seaman MA, D.Phil. Flat 3 ~ 7 Priory Courtyard PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate ~ Kent, CT11 9PW, UK -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEAREDAAYFAkjkhLYACgkQ3jDkPpsZ+VYlrQCgs+tBSJfxa8cKHF+oYsu5Cai2 qZEAoJ6lZupzjapi9ugrE20Jp6Ol1xxj =PMs9 -----END PGP SIGNATURE-----