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 <[EMAIL PROTECTED]> 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 > > > > _______________________________________________ > > [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]" > -- COBRA Lab in NTU EE IAS Lab in SINICA IIS _______________________________________________ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"