From owner-freebsd-questions@FreeBSD.ORG Thu May 26 17:45:30 2005 Return-Path: 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 3876716A41C for ; Thu, 26 May 2005 17:45:30 +0000 (GMT) (envelope-from barry.byrne@wbtsystems.com) Received: from mail.wbtsystems.com (onyx.dublin.wbtsystems.com [193.120.231.6]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8EB6743D1F for ; Thu, 26 May 2005 17:45:28 +0000 (GMT) (envelope-from barry.byrne@wbtsystems.com) Received: from SUNYA (SUNYA.dublin.wbtsystems.com [193.120.231.160]) (authenticated bits=0) by mail.wbtsystems.com (8.12.11/8.12.11) with ESMTP id j4QHjOIe029795; Thu, 26 May 2005 18:45:24 +0100 (IST) Message-Id: <200505261745.j4QHjOIe029795@mail.wbtsystems.com> From: "Barry Byrne" To: "'Matt Virus'" , "'freebsd'" Date: Thu, 26 May 2005 18:45:23 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 In-Reply-To: <429604F3.1050806@navix.net> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 Thread-Index: AcViFxz8b/iXvLt1S8WeaEfdr7XALAAAobIQ X-WBT-Authenticated-User: bb X-Scanned-By: MIMEDefang 2.39 Cc: Subject: RE: Mysql vs /var partition... X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 26 May 2005 17:45:30 -0000 > -----Original Message----- > From: owner-freebsd-questions@freebsd.org > My mysql database is growing, it has subsequently filled the /var/db > partition to capacity. > I tried moving the mysql dir and symlinking it to /var/db/mysql which > didn't work. I also tried mount_null from the /usr partition to the > /var/db/mysql folder...in both instances, the mysql server > will not start. > Is there another way around this problem or do i need to > somehow resize > my /var partition? Matt: Most likely a permissions problem. I generally create a new directory on a different partition for the mysql data. You might want to use tar to preserve your permissions Something like this should work: Enusre mysql server is stopped mkdir /data/mysql chown mysql:mysql /data/mysql chmod 700 /data/mysql cd /var/db/mysql tar cf - . | ( cd /data/mysql ; tar xvf - ) mv /var/db/mysql /var/db/mysql.old ln -s /data/mysql /var/db/mysql Restart mysql Check the ownerships/permissions of the existing /var/db/mysql to be sure of what you need. - Barry