Moving MySQL database

[Alan, Cheng-Lung Sung]

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



-- 
COBRA Lab in NTU EE
IAS Lab in SINICA IIS