From owner-freebsd-questions@FreeBSD.ORG  Fri Jan  4 16:56:55 2008
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 5F57E16A418
	for <freebsd-questions@freebsd.org>;
	Fri,  4 Jan 2008 16:56:55 +0000 (UTC)
	(envelope-from barry.byrne@wbtsystems.com)
Received: from hermes.wbtsystems.com (hermes.wbtsystems.com [193.120.231.28])
	by mx1.freebsd.org (Postfix) with ESMTP id 20E5B13C4D9
	for <freebsd-questions@freebsd.org>;
	Fri,  4 Jan 2008 16:56:55 +0000 (UTC)
	(envelope-from barry.byrne@wbtsystems.com)
Received: from SUNYA (sunya.wbt.wbtsystems.com [10.12.1.197])
	by hermes.wbtsystems.com (Postfix) with ESMTP id 6E4FDF742B;
	Fri,  4 Jan 2008 16:56:53 +0000 (GMT)
From: "Barry Byrne" <barry.byrne@wbtsystems.com>
To: "'zbigniew szalbot'" <zbigniew@szalbot.homedns.org>,
	<freebsd-questions@freebsd.org>
References: <477E6215.8030309@szalbot.homedns.org>
Date: Fri, 4 Jan 2008 16:56:41 -0000
Message-ID: <016901c84ef2$c7945b60$c5010c0a@SUNYA>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 11
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
In-Reply-To: <477E6215.8030309@szalbot.homedns.org>
Thread-Index: AchO8jBVusr0/WqOTXKN7gPpR5/OVQAAHsrw
Cc: 
Subject: RE: changing mysql datadir
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: Fri, 04 Jan 2008 16:56:55 -0000

> -----Original Message-----
> From: owner-freebsd-questions@freebsd.org 
> [mailto:owner-freebsd-questions@freebsd.org] On Behalf Of 

> Wonder if you know whether it is possible to change mysql server data 
> dir from the default /var/db/mysql. I looked through my-small.cnf but 
> found no option called datadir.
> 
> If anyone knows how to change or where to look for 
> compile-time options 
> to set a custom datadir, I'd very much appreciate a link. I 
> was able to 

Put the following in /etc/rc.conf

mysql_dbdir="/path/to/datadir"

 - barry