From owner-freebsd-newbies@FreeBSD.ORG Mon Feb 28 19:10:02 2005 Return-Path: Delivered-To: freebsd-newbies@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 05C7E16A4CE for ; Mon, 28 Feb 2005 19:10:01 +0000 (GMT) Received: from smtp-out1.blueyonder.co.uk (smtp-out1.blueyonder.co.uk [195.188.213.4]) by mx1.FreeBSD.org (Postfix) with ESMTP id 692BE43D58 for ; Mon, 28 Feb 2005 19:10:00 +0000 (GMT) (envelope-from alex.shaw@bulletonline.com) Received: from zaphod.icarix.net ([81.171.196.56]) by smtp-out1.blueyonder.co.uk with Microsoft SMTPSVC(5.0.2195.6713); Mon, 28 Feb 2005 18:07:37 +0000 Date: Mon, 28 Feb 2005 18:06:10 +0000 From: Alex Shaw To: James Alexander Cook Message-ID: <20050228180610.4dd6d6b9@zaphod.icarix.net> In-Reply-To: <20050228142448.GA73739@angel.falsifian.afraid.org> References: <20050228084358.QKAL13819.fed1rmmtao12.cox.net@geraldligh> <20050228142448.GA73739@angel.falsifian.afraid.org> Organization: BulletOnline X-Mailer: Sylpheed-Claws 1.0.0 (GTK+ 1.2.10; i386-portbld-freebsd5.3) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 28 Feb 2005 18:07:37.0490 (UTC) FILETIME=[6296BF20:01C51DC0] cc: Gerald Lightsey cc: freebsd-newbies@freebsd.org Subject: Re: What am I doing wrong with MOUNT? X-BeenThere: freebsd-newbies@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Gathering place for new users List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 28 Feb 2005 19:10:02 -0000 just a thought, if you need more room for you mysql db's why not mount the new drive as /db for example and just change the datadir variable in your my.cnf so your not using the /var drive for databases .... ?? On Mon, 28 Feb 2005 09:24:48 -0500 James Alexander Cook wrote: > On Mon, Feb 28, 2005 at 12:43:44AM -0800, Gerald Lightsey wrote: > > > > I mounted the new drive 1 to a temporary mount point and used the cp command > > to copy each directory in /var to the drive. I looked in all the new/old > > directories at the temporary mount point using ls -F and everything appeared > > to be there at the file level. I used the umount command to unmount the new > > drive/partition from the temporary mount point and remounted it at /var. I > > sysinstall usually gives /var its own partition when you install FreeBSD, so > you probably already had something mounted on /var before you started moving > things over. Try unmounting the thing that was previously mounted on /var > before mounting the new disk; I'm not sure how mount deals with more than one > filesystem mounted at the same place. If that doesn't work, send the output of > ``df'' to the list after unmounting the old /var and mounting the new one. > > Oh, and don't forget to update /etc/fstab once you get everything working. > > > opened MySQL and created the named database I wanted and again started to > > collect the data from the CD by directing the .SQL file data to my database. > > Again, just like it did originally, after several minutes of creating tables > > the system reported that it had run out of space. > > > > My surprise is that every indication I get after I regain control of the > > system is that the database tables are being built within the original /var > > directory structure rather than the 120gb drive mounted on the /var > > mountpoint. If I use the df command while drive 1 is mounted it shows that > > /var on disk 0 is full and /var on disk 1 just has whatever I copied onto > > the drive when it was mounted to a temporary mount point. Also by > > experimentation/confirmation I find that simply creating a couple of new > > databases within MySQL while drive 1 is mounted on /var shows that the > > databases have been created on the original /var on disk 0 as directories > > after disk 1 is unmounted. > > > > What am I doing wrong or what don't I understand about a drive being mounted > > on /var where data is being written underneath it to the original > > /var/db/mysql/mydatabasename on disk 0 rather than onto the mounted disk 1? > > > > Thanks, > > > > Gerald > _______________________________________________ > freebsd-newbies@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-newbies > To unsubscribe, send any mail to "freebsd-newbies-unsubscribe@freebsd.org" >