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. > <snip> > > 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 > > _______________________________________________ > [EMAIL PROTECTED] mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" > _______________________________________________ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"