From owner-freebsd-questions@FreeBSD.ORG Wed Sep 8 20:40:32 2004 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 4642616A4CE for ; Wed, 8 Sep 2004 20:40:32 +0000 (GMT) Received: from clunix.cl.msu.edu (clunix.cl.msu.edu [35.9.2.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id D33B543D2F for ; Wed, 8 Sep 2004 20:40:31 +0000 (GMT) (envelope-from jerrymc@clunix.cl.msu.edu) Received: (from jerrymc@localhost) by clunix.cl.msu.edu (8.11.7p1+Sun/8.11.7) id i88Ke1L27271; Wed, 8 Sep 2004 16:40:01 -0400 (EDT) From: Jerry McAllister Message-Id: <200409082040.i88Ke1L27271@clunix.cl.msu.edu> To: bsilver@chrononomicon.com (Bart Silverstrim) Date: Wed, 8 Sep 2004 16:40:01 -0400 (EDT) In-Reply-To: from "Bart Silverstrim" at Sep 08, 2004 03:19:09 PM X-Mailer: ELM [version 2.5 PL2] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit cc: freebsd-questions@freebsd.org Subject: Re: Moving MySQL database 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, 08 Sep 2004 20:40:32 -0000 Hi, > On Sep 3, 2004, at 10:46 AM, Jerry McAllister wrote: > >> I have a server that is rapidly filling the var partition with a MySQL > >> database. I'd like to move it to a subdirectory somewhere under /usr. > > > If you don't want to move all the stuff in /var/db, then you will > > have to be more selective and make the link from within /var/db > > rather than just the whole db directory from within /var. > > > > For example, the MySQL stuff is likely to all be in a directory > > called /var/db/mysql. So: > > > > Stop MySQL or reboot to single user. > > Then > > cd /var/db/mysql > > tar cf /usr/mysql.tar * > > cd /usr > > mkdir var.db.mysql > > cd var.db.mysql > > tar xf ../../mysql.tar > > cd /var/db > > mv mysql mysql.old > > ln -s /usr/var.db.mysql mysql > > Now, reboot and let MySQL start and make sure it all is happy and > > works just fine. > > Then clean up. > > cd /usr > > rm mysql.tar > > cd /var/db > > rm -rf mysql.old > > > > ////jerry > > Thank you to everyone who replied. I followed the above steps and the > SQL server seems to be happy and running on the /usr partition instead > of /var for now. We'll be watching it, and if all seems to be working > well, we'll delete the old data off /var. > > Thanks again! (especially for the specific directions on moving the > data over, Jerry...) Good. I am glad it works for you. It seemed to be shorter and more clear to just make an example than to try and write out an explaination for it. ////jerry > > -Bart > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" >