From owner-freebsd-fs@FreeBSD.ORG Thu Mar 26 17:36:44 2009 Return-Path: Delivered-To: fs@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 5AD4810656CA for ; Thu, 26 Mar 2009 17:36:44 +0000 (UTC) (envelope-from tevans.uk@googlemail.com) Received: from mail-fx0-f167.google.com (mail-fx0-f167.google.com [209.85.220.167]) by mx1.freebsd.org (Postfix) with ESMTP id A541F8FC19 for ; Thu, 26 Mar 2009 17:36:43 +0000 (UTC) (envelope-from tevans.uk@googlemail.com) Received: by fxm11 with SMTP id 11so649000fxm.43 for ; Thu, 26 Mar 2009 10:36:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=gamma; h=domainkey-signature:received:received:subject:from:to:cc :in-reply-to:references:content-type:date:message-id:mime-version :x-mailer:content-transfer-encoding; bh=4X+bXXEfsdrDlXkMPxAHfDK5WuKa5x7vOhQU3ZA9bPM=; b=KqVrgu14mhALpedyKTBRpIl89xAKphxpdfOfLvP04qggL114W3hwq/J2eVReh+YlbZ IbKK3Ij9GdJL9Cs5qWTA+0P5fr9A1/sqR3SoX5vMaLObPwQWZyBlXTzULu2vVSHSFQ9Q UcNKa+jeWhc3lmV5HirCCYiQ7dVv+M+qraT3A= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma; h=subject:from:to:cc:in-reply-to:references:content-type:date :message-id:mime-version:x-mailer:content-transfer-encoding; b=si7Y3NHPt9X/QBfGSByiCVmmrOCz5el53TGBEke8/4wwQ4zaug3fZmW2ZFnGRixPy0 uuui0/VkXINPehKl6tLYq0z7IVw+ajqUTx2EZit7/PDkDTP5WuDksGAt4Pc63VbfdFbf SjK3PbIKNds2pTykFHr4vbzJ3BUSeAnvGDJRs= Received: by 10.86.94.11 with SMTP id r11mr1399444fgb.53.1238087477636; Thu, 26 Mar 2009 10:11:17 -0700 (PDT) Received: from ?127.0.0.1? (87-194-39-182.bethere.co.uk [87.194.39.182]) by mx.google.com with ESMTPS id e11sm643209fga.20.2009.03.26.10.11.16 (version=SSLv3 cipher=RC4-MD5); Thu, 26 Mar 2009 10:11:17 -0700 (PDT) From: Tom Evans To: Jake Scott In-Reply-To: References: <3.0.1.32.20090326065337.00f081e0@sage-american.com> <3.0.1.32.20090325072137.00ee6b48@sage-american.com> <49C9E635.5010106@kkip.pl> <49C83673.3000604@aldan.algebra.com> <200903251820.54749.doconnor@gsoft.com.au> <200903251925.36108.doconnor@gsoft.com.au> <3.0.1.32.20090325072137.00ee6b48@sage-american.com> <3.0.1.32.20090326065337.00f081e0@sage-american.com> <3.0.1.32.20090326070807.00f081e0@sage-american.com> <200903261331.n2QDVd4b038485@lava.sentex.ca> <20090326140131.GA45201@hyperion.scode.org> Content-Type: text/plain Date: Thu, 26 Mar 2009 17:11:15 +0000 Message-Id: <1238087475.7491.44.camel@strangepork.mintel.co.uk> Mime-Version: 1.0 X-Mailer: Evolution 2.22.3.1 FreeBSD GNOME Team Port Content-Transfer-Encoding: 7bit Cc: "Jack L. Stone" , fs@freebsd.org, freebsd-stable@freebsd.org Subject: Re: support quality (Re: dump | restore fails: unknown tape headertype 1853384566) X-BeenThere: freebsd-fs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Filesystems List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 26 Mar 2009 17:36:44 -0000 On Thu, 2009-03-26 at 14:45 +0000, Jake Scott wrote: .. > Absolutely. You really must use a tool that interacts with the database > to perform the backup. Most commercial DBs have hooks that allow the > backup routines to call out to custom snapshot facilities. One would > usually request a backup through the database, which would then freeze IO > to its data files and maybe log files, deal with flushing caches etc and > then call your snapshot routine. I'm not aware that MySQL and Postgres do > though so the best you can do is a dump. > > > Jake > Just to add, mysql has a utility (mysqlhotcopy) to allow you to directly copy MyISAM databases with a guarentee of consistency (thus avoiding the conversion from MyISAM data -> SQL, and no need to reimport when recovering). It isn't exactly online though, any writes will be blocked until the hotcopy finishes. Still, it is only MyISAM, and not much call for that these days.. Cheers Tom