From owner-freebsd-questions@FreeBSD.ORG Wed Mar 10 07:12:43 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1D00E16A4CE for ; Wed, 10 Mar 2004 07:12:43 -0800 (PST) Received: from clunix.cl.msu.edu (clunix.cl.msu.edu [35.9.2.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id A32BF43D45 for ; Wed, 10 Mar 2004 07:12:42 -0800 (PST) (envelope-from jerrymc@clunix.cl.msu.edu) Received: (from jerrymc@localhost) by clunix.cl.msu.edu (8.11.7p1+Sun/8.11.7) id i2AFCY608017; Wed, 10 Mar 2004 10:12:34 -0500 (EST) From: Jerry McAllister Message-Id: <200403101512.i2AFCY608017@clunix.cl.msu.edu> To: gpeel@thenetnow.com Date: Wed, 10 Mar 2004 10:12:34 -0500 (EST) In-Reply-To: <002001c406b0$e5c46280$6601a8c0@grant> from "Grant Peel" at Mar 10, 2004 10:03:50 AM X-Mailer: ELM [version 2.5 PL2] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit cc: freebsd-questions@freebsd.org Subject: Re: Restore command line options X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 10 Mar 2004 15:12:43 -0000 > > How about I post this again, without the typo's :-O > > Hi all, > > I recently had the opertunity to restore a clients mysql db as he had > removed a bunch of needed data from his shopping cart. > > While the restore command worked OK I was wondering if there is a way to > command line it a bit so as not to have to answer yes when asked about the > file privledges and have to specify a '1' when asked what volume to use. (I > am used to working with tar and doing everything in a single command). > > The full backup and incremental backup files I used were in a /home/backup. > The target files were of course in /usr/local/mysql/var/DBNAME > > Here is the command I used: > > restore -x -f /home/backup/usr.level-1_dump local/mysql/var/DBDIRNAMEHERE > > Have I missed some command line options here to avoide having to answer the > perms and volume questions? I don't think you have missed anything. It is one of the little annoyances with dump/restore - which still do not add up to enough to overweigh the value of using them. You could write a wrapper script that would feed the 1 and yes(or no that you may really want to give). ////jerry > > -Grant >