Date: Wed, 8 Sep 2004 15:19:09 -0400 From: Bart Silverstrim <bsilver@chrononomicon.com> To: freebsd-questions@freebsd.org Subject: Re: Moving MySQL database Message-ID: <F582A04F-01CB-11D9-8444-000D9338770A@chrononomicon.com> In-Reply-To: <200409031446.i83EkAi02437@clunix.cl.msu.edu> References: <200409031446.i83EkAi02437@clunix.cl.msu.edu>
next in thread | previous in thread | raw e-mail | index | archive | help
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...) -Bart
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?F582A04F-01CB-11D9-8444-000D9338770A>