From owner-freebsd-questions@FreeBSD.ORG  Fri Jul 27 08:06:45 2007
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id B163016A418
	for <freebsd-questions@freebsd.org>;
	Fri, 27 Jul 2007 08:06:45 +0000 (UTC)
	(envelope-from sonicy@otenet.gr)
Received: from aiolos.otenet.gr (aiolos.otenet.gr [195.170.0.93])
	by mx1.freebsd.org (Postfix) with ESMTP id 2BFA513C45D
	for <freebsd-questions@freebsd.org>;
	Fri, 27 Jul 2007 08:06:44 +0000 (UTC)
	(envelope-from sonicy@otenet.gr)
Received: from freebsdgr.dyndns.org (athedsl-290521.home.otenet.gr
	[85.73.182.119]) (authenticated bits=0)
	by aiolos.otenet.gr (8.13.8/8.13.8/Debian-3) with ESMTP id
	l6R86gOe011880; Fri, 27 Jul 2007 11:06:42 +0300
Message-ID: <46A9A792.3000805@otenet.gr>
Date: Fri, 27 Jul 2007 11:06:42 +0300
From: Manolis Kiagias <sonicy@otenet.gr>
User-Agent: Thunderbird 2.0.0.5 (X11/20070721)
MIME-Version: 1.0
To: Zbigniew Szalbot <zbigniew@szalbot.homedns.org>
References: <359b36a4250a7259fba7a219b1f82bf4@szalbot.homedns.org>
In-Reply-To: <359b36a4250a7259fba7a219b1f82bf4@szalbot.homedns.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Cc: Freebsd questions <freebsd-questions@freebsd.org>
Subject: Re: mysql upgrade from 5.0.27 to 5.0.45
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: Fri, 27 Jul 2007 08:06:45 -0000

Zbigniew Szalbot wrote:
> Hello,
>
> I currently have mysql Ver 14.12 Distrib 5.0.27. I can see that the most
> current ports version is 5.0.45. So I tried to portupgrade and it tells me:
>
> --->  Session started at: Fri, 27 Jul 2007 09:17:39 +0200
> ** No need to upgrade 'mysql-server-5.0.45' (>= mysql-server-5.0.45).
> (specify -f to force)
> --->  ** Upgrade tasks 1: 0 done, 1 ignored, 0 skipped and 0 failed
> --->  Listing the results (+:done / -:ignored / *:skipped / !:failed)
>         - databases/mysql50-server (mysql-server-5.0.45)
> --->  Packages processed: 0 done, 1 ignored, 0 skipped and 0 failed
> --->  Session ended at: Fri, 27 Jul 2007 09:17:44 +0200 (consumed 00:00:04)
>
> I know I can use -f to upgrade but why would it say that there is no need
> to upgrade when the versions differ so much?
>
> Thank you in advance!
>
>   
According to your portupgrade messages, you ALREADY have mysql 5.0.45. 
Are you quite sure about the installed version? It might be an error of 
portupgrade or something wrong with your package database, but I surely 
haven't seen it before. Why don't you just confirm your installed 
version with something like:

pkg_info | grep -i mysql-server

In my system this actually shows 5.0.45, and I started with 5.0.2x 
something. I didn't even realise when it was upraded.