From owner-freebsd-questions@FreeBSD.ORG Thu Jun 24 23:15:48 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 530A016A4CE for ; Thu, 24 Jun 2004 23:15:48 +0000 (GMT) Received: from galilee.polands.org (CPE-24-208-53-189.new.rr.com [24.208.53.189]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7886B43D48 for ; Thu, 24 Jun 2004 23:15:47 +0000 (GMT) (envelope-from doug@polands.org) Received: from polands.org (jericho.polands.org [172.16.1.35]) by galilee.polands.org (8.12.9/8.12.9) with ESMTP id i5ONMCGk072868 for ; Thu, 24 Jun 2004 18:22:12 -0500 (CDT) (envelope-from doug@polands.org) Message-ID: <40DB608C.3040302@polands.org> Date: Thu, 24 Jun 2004 18:15:24 -0500 From: Doug Poland User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.6) Gecko/20040409 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "freebsd-questions@freebsd.org" Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Subject: 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: Thu, 24 Jun 2004 23:15:48 -0000 Hello, Does someone have a strategy for upgrading MySQL? For example, I'm currently running 5.2.1-RELEASE with mysql-server-4.1.1_2. The current MySQL version is 4.1.2. If I simply run portupgrade, will the new MySQL binary be "OK" with the older-style database files? If I were to dump the 4.1.1 files then restore, there may have been changes in the schema that could make this problematic. 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. Thanks for your help. -- Regards, Doug