Date: Thu, 9 Sep 2004 09:18:46 +0800 From: "Alan, Cheng-Lung Sung" <clsung@gmail.com> To: Jerry McAllister <jerrymc@clunix.cl.msu.edu> Cc: Bart Silverstrim <bsilver@chrononomicon.com> Subject: Re: Moving MySQL database Message-ID: <8c0cd475040908181870e14639@mail.gmail.com> In-Reply-To: <200409082040.i88Ke1L27271@clunix.cl.msu.edu> References: <F582A04F-01CB-11D9-8444-000D9338770A@chrononomicon.com> <200409082040.i88Ke1L27271@clunix.cl.msu.edu>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi,
Why not just use mysqldump --alldatabases ?
Export all, then import all.
It can make sure all your DB data consistency.
Regards,
On Wed, 8 Sep 2004 16:40:01 -0400 (EDT), Jerry McAllister
<jerrymc@clunix.cl.msu.edu> wrote:
> 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
> >
> > _______________________________________________
> > 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"
> >
>
> _______________________________________________
> 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"
>
--
COBRA Lab in NTU EE
IAS Lab in SINICA IIS
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?8c0cd475040908181870e14639>