From owner-freebsd-ports@FreeBSD.ORG Mon Jun 18 23:07:16 2007 Return-Path: X-Original-To: ports@FreeBSD.org Delivered-To: freebsd-ports@FreeBSD.ORG Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 4FB1C16A400; Mon, 18 Jun 2007 23:07:16 +0000 (UTC) (envelope-from kris@obsecurity.org) Received: from elvis.mu.org (elvis.mu.org [192.203.228.196]) by mx1.freebsd.org (Postfix) with ESMTP id 3CFC513C45A; Mon, 18 Jun 2007 23:07:16 +0000 (UTC) (envelope-from kris@obsecurity.org) Received: from obsecurity.dyndns.org (elvis.mu.org [192.203.228.196]) by elvis.mu.org (Postfix) with ESMTP id 8E0CF1A4D8C; Mon, 18 Jun 2007 16:06:29 -0700 (PDT) Received: from rot13.obsecurity.org (rot13.obsecurity.org [192.168.1.5]) by obsecurity.dyndns.org (Postfix) with ESMTP id 76ED751264; Mon, 18 Jun 2007 19:07:15 -0400 (EDT) Received: by rot13.obsecurity.org (Postfix, from userid 1001) id 653C0C296; Mon, 18 Jun 2007 19:07:15 -0400 (EDT) Date: Mon, 18 Jun 2007 19:07:15 -0400 From: Kris Kennaway To: Bob , ale@FreeBSD.org, ports@FreeBSD.org Message-ID: <20070618230715.GA78950@rot13.obsecurity.org> References: <20070618230241.GA18844@eos.sc1.parodius.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20070618230241.GA18844@eos.sc1.parodius.com> User-Agent: Mutt/1.4.2.3i Cc: Subject: Re: FreeBSD Port: mysql-server-3.23.59.n.20050301_3 X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 18 Jun 2007 23:07:16 -0000 On Mon, Jun 18, 2007 at 04:02:41PM -0700, Jeremy Chadwick wrote: > On Mon, Jun 18, 2007 at 06:41:23PM -0400, Bob wrote: > > First the port allocates the location for the databases to /var/db/mysql. > > This location has no space allocated to hold database data. > > It should be changed to /usr/local/mysql > > You're complaining about the default location of mysql_dbdir, which is > somewhat understandable. /var/db/mysql is a good place for it. > Ideally, the /var filesystem should be increased when choosing > [A]utomatic during filesystem creation (I believe it picks 2GB or > something like that), but that's not the responsibility of -ports. > > The size of each filesystem is up to you to decide; sticking everything > blindly into /usr or subtrees of /usr (e.g. /usr/local) simply because > FreeBSD defaults to "all remaining space --> /usr" doesn't justify > laziness during initial filesystem creation time. Yes, I realise some > other ports do this (Apache for example, although it's quite justified > for Apache), and they probably shouldn't. Deciding if ports should > install themselves into LOCALBASE/portname or not is quite political, I > think... > > Anyways, what you can do is install MySQL normally, which of course > drops the MySQL database structure into /var/db/mysql. Once there, you > can move that directory to someplace of your choice (/usr/local/mysql or > /home/mysql or whatever you want), then modify rc.conf to say > mysql_dbdir="/wherever/mysql". pkg_delete/deinstalling the mysql-server > port won't nuke contents of that directory, and future installations (as > long as the existing mysql/* tables exist in mysql_dbdir) will skip > installing out-of-the-box MySQL databases/tables. Or just symlink it. Kris