From owner-freebsd-questions@FreeBSD.ORG Wed Dec 17 13:25:26 2003 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 E4F5A16A4CE for ; Wed, 17 Dec 2003 13:25:26 -0800 (PST) Received: from main.gmane.org (main.gmane.org [80.91.224.249]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5E13943D1F for ; Wed, 17 Dec 2003 13:25:24 -0800 (PST) (envelope-from freebsd-questions@m.gmane.org) Received: from list by main.gmane.org with local (Exim 3.35 #1 (Debian)) id 1AWjAZ-0004eT-00 for ; Wed, 17 Dec 2003 22:25:23 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-questions@freebsd.org Received: from sea.gmane.org ([80.91.224.252]) by main.gmane.org with esmtp (Exim 3.35 #1 (Debian)) id 1AWjAX-0004eL-00 for ; Wed, 17 Dec 2003 22:25:21 +0100 Received: from news by sea.gmane.org with local (Exim 3.35 #1 (Debian)) id 1AWjAX-0003s9-00 for ; Wed, 17 Dec 2003 22:25:21 +0100 From: "Scott I. Remick" Date: Wed, 17 Dec 2003 16:25:20 -0500 Lines: 23 Message-ID: References: <20031217160458.86196.qmail@web60307.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.) X-Archive: encrypt Sender: news Subject: Re: Increase space for /var/db/ 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, 17 Dec 2003 21:25:27 -0000 On Wed, 17 Dec 2003 08:04:58 -0800, samy lancher wrote: > I have a 4.5 FreeBSD server with mysql database. only 250MB was allocated > to /var/db. Our database is increasing so fast that now i need to expand > the memory for /var/db. I guess one way to do is to install a new hard > drive and then mount it to /var/db. But i would like to know if there is > any other way to solve that problem. Is making a soft link a good idea. i > have 70GB in /usr/ so i would like to map /var/db/ to some location in > /usr/. Please let me know if anyone has any suggestions. First time I had to do this I did the link suggestion that other people have posted. But you have another cleaner option w/ MySQL. There is a my.cnf file where you can set a DATADIR variable (I think that's what it's called) to set the path for the database files. Then you can point that to /usr/mysql or whatever. Just read up on my.cnf and how it's used for more info. It either goes in /etc or /usr/local/etc I think. The reason I'm vague is that I don't do it that way myself. I use the /usr/local/etc/rc.d/ scripts (which I don't think were used in 4.5?) so I have an option right within the mysql-server.sh script there for setting the datadir (DB_DIR).