Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 30 May 2003 04:23:12 +0100
From:      Jez Hancock <jez.hancock@munk.nu>
To:        freebsd-questions@freebsd.org
Subject:   Re: Mysql
Message-ID:  <20030530032312.GB48510@users.munk.nu>
In-Reply-To: <PPECLBJKHADMJKGPJMEFCEBDCKAA.ian@cerebellum.za.net>
References:  <PPECLBJKHADMJKGPJMEFCEBDCKAA.ian@cerebellum.za.net>

next in thread | previous in thread | raw e-mail | index | archive | help
On Thu, May 29, 2003 at 06:08:53PM +0200, Ian Barnes wrote:
> Hi,
> 
> I want to remove my mysql installation and re-install from scratch. Now the
> problem. I have 6 active databases. How can i make sure that i dont loose
> those. And that when i have re-installed, that they work immediatilly ??
fwiw you can simply do:
cd /var/db
mv mysql mysql.bak
(uninstall/reinstall w/e mysql)
rm -fr /var/db/mysql
mv /var/db/mysql.bak /var/db/mysql

afaik using something as complicated as tar to archive the dbs first
isn't necessary - mv retains the permission settings fine.



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030530032312.GB48510>