From owner-freebsd-questions@FreeBSD.ORG  Thu Feb 23 06:12:11 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
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 7A49716A420
	for <freebsd-questions@freebsd.org>;
	Thu, 23 Feb 2006 06:12:11 +0000 (GMT)
	(envelope-from dan@dan.emsphone.com)
Received: from dan.emsphone.com (dan.emsphone.com [199.67.51.101])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 1974743D46
	for <freebsd-questions@freebsd.org>;
	Thu, 23 Feb 2006 06:12:10 +0000 (GMT)
	(envelope-from dan@dan.emsphone.com)
Received: (from dan@localhost)
	by dan.emsphone.com (8.13.1/8.13.4) id k1N6C7VZ097595;
	Thu, 23 Feb 2006 00:12:07 -0600 (CST) (envelope-from dan)
Date: Thu, 23 Feb 2006 00:12:07 -0600
From: Dan Nelson <dnelson@allantgroup.com>
To: James Long <list@museum.rain.com>
Message-ID: <20060223061206.GB55021@dan.emsphone.com>
References: <20060223040819.GA94519@ns.museum.rain.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20060223040819.GA94519@ns.museum.rain.com>
X-OS: FreeBSD 5.4-STABLE
X-message-flag: Outlook Error
User-Agent: Mutt/1.5.11
Cc: freebsd-questions@freebsd.org
Subject: Re: ports/databases/mysql50-server: where is mysql_upgrade ?
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 23 Feb 2006 06:12:11 -0000

In the last episode (Feb 22), James Long said:
> Section 5.6.2 of the MySQL 5.0 docs says:
> 
> 5.6.2. mysql_upgrade -- Check Tables for MySQL Upgrade
> 
> mysql_upgrade should be executed each time you upgrade MySQL. It 
> checks all tables in all databases for incompatibilities with the 
> current version of MySQL Server.
> 
> After installing mysql50-server, there is no mysql_upgrade on
> my system:

At the bottom of that section is this sentence:

    mysql_upgrade was added in MySQL 5.0.19. It supersedes the older
    mysql_fix_privilege_tables script.

5.0.19 hasn't been released yet, but I expect that when it is, and the
port is updated to build it, the command will be available.

-- 
	Dan Nelson
	dnelson@allantgroup.com