Date: Wed, 27 Jun 2007 06:36:15 -0700 From: Jeremy Chadwick <koitsu@FreeBSD.org> To: Jack Stone <antennex@hotmail.com> Cc: freebsd-ports@freebsd.org Subject: Re: Upgrading MySQL port Message-ID: <20070627133615.GA41868@eos.sc1.parodius.com> In-Reply-To: <BAY125-F273D7FBCAF6FD5A02968DBCC0A0@phx.gbl> References: <BAY125-F273D7FBCAF6FD5A02968DBCC0A0@phx.gbl>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, Jun 27, 2007 at 07:14:09AM -0500, Jack Stone wrote: > I need to upgrade the older generation of MySQL from 3x to 4x and without > loss of the existing DBs. > > What's the best approach of doing this when jumping a generation in MySQL > and keeping DBs safe in the process? This is really not a question for -ports. This is something you should be asking the MySQL folks. In fact, better yet, there's an entire section on how to backup/restore entire databases. Be aware that migrating your mysql/ database is a testy thing, and if at all possible, read the docs thoroughly or do it by hand. http://dev.mysql.com/doc/refman/4.1/en/upgrade.html http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html http://dev.mysql.com/doc/refman/4.1/en/disaster-prevention.html -- | Jeremy Chadwick jdc at parodius.com | | Parodius Networking http://www.parodius.com/ | | UNIX Systems Administrator Mountain View, CA, USA | | Making life hard for others since 1977. PGP: 4BD6C0CB |
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20070627133615.GA41868>