From owner-freebsd-questions@FreeBSD.ORG  Tue Oct 24 23:56:19 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: 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 DD85C16A407
	for <freebsd-questions@freebsd.org>;
	Tue, 24 Oct 2006 23:56:19 +0000 (UTC)
	(envelope-from freebsd@philip.pjkh.com)
Received: from bravo.pjkh.com (bravo.pjkh.com [72.36.232.219])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 81FF343D66
	for <freebsd-questions@freebsd.org>;
	Tue, 24 Oct 2006 23:56:19 +0000 (GMT)
	(envelope-from freebsd@philip.pjkh.com)
Received: from bravo.pjkh.com (bravo.pjkh.com [72.36.232.219])
	by bravo.pjkh.com (Postfix) with ESMTP id 47F8113D770;
	Tue, 24 Oct 2006 19:03:45 -0500 (CDT)
Received: by bravo.pjkh.com (Postfix, from userid 1000)
	id 16A8313D76F; Tue, 24 Oct 2006 19:03:45 -0500 (CDT)
Received: from localhost (localhost [127.0.0.1])
	by bravo.pjkh.com (Postfix) with ESMTP id 1599613D76E;
	Tue, 24 Oct 2006 19:03:45 -0500 (CDT)
Date: Tue, 24 Oct 2006 19:03:45 -0500 (CDT)
From: Philip Hallstrom <freebsd@philip.pjkh.com>
To: Jonathan Horne <freebsd@dfwlp.com>
In-Reply-To: <200610241849.50723.freebsd@dfwlp.com>
Message-ID: <20061024190247.B7554@bravo.pjkh.com>
References: <200610241849.50723.freebsd@dfwlp.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
X-Virus-Scanned: ClamAV using ClamSMTP
Cc: freebsd-questions@freebsd.org
Subject: Re: [OT] a mysql question
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
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, 24 Oct 2006 23:56:19 -0000

> typical OT thread apologies, but the truth *really* is that this is the best
> and most intelligent list i read. so...

You're really going to get better answers from the mysql lists... really. 
:)

> i use veritas netbackup 5.1 to backup my bsd machines, and i would like to
> restore some mysql databases onto another machine.  is restoring any mysql
> database, as simple as reloading the database directories in /var/db/mysql?
> do i need to create the blank database first, then do it?

maybe. maybe not.  depends on the engine's used.

http://dev.mysql.com/doc/refman/5.0/en/backup.html
http://jeremy.zawodny.com/mysql/mysql-backup-and-recovery.html

-philip