From owner-freebsd-isp Mon Sep 30 5:34:44 2002 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 463EE37B401 for ; Mon, 30 Sep 2002 05:34:42 -0700 (PDT) Received: from newnet.co.uk (newnet.co.uk [212.87.80.12]) by mx1.FreeBSD.org (Postfix) with ESMTP id 571B043E6A for ; Mon, 30 Sep 2002 05:34:41 -0700 (PDT) (envelope-from jamie@jamiesdomain.org.uk) Received: from BONG (perry-gw-nat1-eth1.router.trident-uk.co.uk [81.3.89.49]) by newnet.co.uk (8.12.3/8.12.3) with SMTP id g8UCYEkW068563; Mon, 30 Sep 2002 13:34:15 +0100 (BST) (envelope-from jamie@jamiesdomain.org.uk) Message-ID: <00cf01c2687d$a3c829c0$3264a8c0@BONG> Reply-To: "Jamie Heckford" From: "Jamie Heckford" To: "Troy Settle" Cc: References: <000201c2687b$1f2c0580$2615c518@psknet.com> Subject: Re: gzip / tar files in use Date: Mon, 30 Sep 2002 13:33:54 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Newnet-MailScanner: Found to be clean Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org I normally use PHPMyAdmin for speed when setting up simple databases that don't have things like dynamic tables, the export/backup utility in that seems to work fairly well - if your not looking for an automated backup that you can run from say a cron job. Jamie ----- Original Message ----- From: "Troy Settle" To: ; Sent: Monday, September 30, 2002 1:15 PM Subject: RE: gzip / tar files in use > > Chem, > > This will result in an incomplete backup of your databases. I would > recommend using mysqldump first, then tarr/gzip the resulting file(s). > > -- > Troy Settle > Pulaski Networks > 540.994.4254 - 866.477.5638 > http://www.psknet.com > > > > -----Original Message----- > > From: owner-freebsd-isp@FreeBSD.ORG > > [mailto:owner-freebsd-isp@FreeBSD.ORG] On Behalf Of chem@i-p-d.nl > > Sent: Monday, September 30, 2002 5:39 AM > > To: freebsd-isp@FreeBSD.ORG > > Subject: gzip / tar files in use > > > > > > Hi, > > > > I was wondering if I can gzip and tar a directory that > > consists of files that are partly in > > use? What will happen to the files that are in use. Are they > > skipped? In this case I > > want to tar and gzip the database-directory of mysql. > > > > TIA > > chem > > > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > > with "unsubscribe freebsd-isp" in the body of the message > > > > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-isp" in the body of the message > -- ____________________________________________________ Message scanned for viruses and dangerous content by and believed to be clean To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message