From owner-freebsd-questions@FreeBSD.ORG Fri Jun 25 05:26:12 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 285B816A4CE for ; Fri, 25 Jun 2004 05:26:12 +0000 (GMT) Received: from davidfuchs.ca (domains1.davidfuchs.ca [216.113.197.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id E6E1D43D31 for ; Fri, 25 Jun 2004 05:26:11 +0000 (GMT) (envelope-from david@davidfuchs.ca) Received: from s0106002078dbe870.vs.shawcable.net ([24.82.197.178] helo=[127.0.0.1]) by davidfuchs.ca with asmtp (Exim 4.30) id 1BdjBL-0001K7-Dq; Thu, 24 Jun 2004 22:23:23 -0700 Message-ID: <40DBB6D8.6070004@davidfuchs.ca> Date: Thu, 24 Jun 2004 22:23:36 -0700 From: David Fuchs User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7) Gecko/20040608 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Doug Poland , freebsd-questions@freebsd.org References: <40DB608C.3040302@polands.org> In-Reply-To: <40DB608C.3040302@polands.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: Upgrading MySQL strategies X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 25 Jun 2004 05:26:12 -0000 Doug Poland wrote: > Does someone have a strategy for upgrading MySQL? > > I've searched the archives and have turned up nothing useful. One would > think this would be covered in MySQL's excellent on-line docs, but I > could find no mention of upgrading. > Hi Doug, As a rule, you shouldn't trust that your database will be compatible with any version of MySQL besides the one it currently runs under. Dumping the database and re-loading it is the best option. Make sure to check the changelog for the new version beforehand, just in case there have been important changes (possible inclusion of new reserved words - things of that nature). Sometimes there are specific processes you need to follow for upgrading certain versions of MySQL (i.e. you'll need to run a contributed script or something) - where applicable, these processes are well-documented. I think a good 'strategy' is the same one you would use for any kind of upgrade - one that allows you to test your changes safely and thoroughly before implementing them. Always backup first, of course. Run both the old and new versions of MySQL side-by-side with separate copies of the database (you'll need to modify your config appropriately to run two copies) and take your time with it to ensure things are running as expected. Section 2.5 of the MySQL documentation has a lot of good information for upgrading. You can view the HTML copy (with user comments) here: http://dev.mysql.com/doc/mysql/en/Upgrade.html -- Thanks, -David Fuchs BCIS (david@davidfuchs.ca) WWW: http://www.davidfuchs.ca/ Blog: http://blog.davidfuchs.ca/ MSN: david@davidfuchs.ca PGP: http://www.davidfuchs.ca/aboutme/433EEC91.pgp