From owner-freebsd-questions@FreeBSD.ORG  Thu Feb 23 04:08:35 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 B995F16A420
	for <freebsd-questions@freebsd.org>;
	Thu, 23 Feb 2006 04:08:35 +0000 (GMT)
	(envelope-from james_mapson@umpquanet.com)
Received: from ns.museum.rain.com (gw-ipinc.museum.rain.com [65.75.192.74])
	by mx1.FreeBSD.org (Postfix) with ESMTP id CD8CD43D53
	for <freebsd-questions@freebsd.org>;
	Thu, 23 Feb 2006 04:08:26 +0000 (GMT)
	(envelope-from james_mapson@umpquanet.com)
Received: from ns.museum.rain.com (localhost [127.0.0.1])
	by ns.museum.rain.com (8.13.4/8.13.4) with ESMTP id k1N48KHM094581
	(version=TLSv1/SSLv3 cipher=DHE-DSS-AES256-SHA bits=256 verify=NO)
	for <freebsd-questions@freebsd.org>;
	Wed, 22 Feb 2006 20:08:20 -0800 (PST)
	(envelope-from james@umpquanet.com)
Received: (from james@localhost)
	by ns.museum.rain.com (8.13.4/8.13.4/Submit) id k1N48JlY094580
	for freebsd-questions@freebsd.org; Wed, 22 Feb 2006 20:08:19 -0800 (PST)
	(envelope-from james)
Date: Wed, 22 Feb 2006 20:08:19 -0800
From: James Long <list@museum.rain.com>
To: freebsd-questions@freebsd.org
Message-ID: <20060223040819.GA94519@ns.museum.rain.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.5.11
X-Spam-Status: No, score=-101.4 required=5.0 tests=ALL_TRUSTED,
	USER_IN_WHITELIST autolearn=failed version=3.1.0
X-Spam-Checker-Version: SpamAssassin 3.1.0 (2005-09-13) on ns.museum.rain.com
Subject: 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 04:08:35 -0000

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:

pe850 : 19:44:15 /root#
[1]+  Done                    ( /usr/libexec/locate.updatedb )
pe850 : 19:44:27 /root# locate mysql_upgrade
pe850 : 19:44:32 /root#


I am building a new server with MySQL 5.0.18 running on FreeBSD
6.1-PRERELEASE and importing data from 3.22.32 running on 
4.4-STABLE.

Where can I locate mysql_upgrade?


Thanks,

Jim