From owner-freebsd-questions@FreeBSD.ORG  Tue Mar  9 09:40:44 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 88F5616A4CE
	for <freebsd-questions@freebsd.org>;
	Tue,  9 Mar 2004 09:40:44 -0800 (PST)
Received: from enterprise.thenetnow.com (enterprise.thenetnow.com
	[65.39.193.152])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 1E6C743D45
	for <freebsd-questions@freebsd.org>;
	Tue,  9 Mar 2004 09:40:44 -0800 (PST)
	(envelope-from gpeel@thenetnow.com)
Received: from grant (hpeel.ody.ca [216.240.12.2])
	by enterprise.thenetnow.com (8.11.6/8.11.6) with SMTP id i29Heav20880
	for <freebsd-questions@freebsd.org>;
	Tue, 9 Mar 2004 12:40:36 -0500 (EST)
	(envelope-from gpeel@thenetnow.com)
Message-ID: <003c01c405fd$ed7be100$6601a8c0@grant>
From: "Grant Peel" <gpeel@thenetnow.com>
To: <freebsd-questions@freebsd.org>
Date: Tue, 9 Mar 2004 12:42:43 -0500
Organization: The Net Now
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.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Subject: Resote COmmand line
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
Reply-To: Grant Peel <gpeel@thenetnow.com>
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: Tue, 09 Mar 2004 17:40:44 -0000

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?

-Grant