From owner-freebsd-questions@FreeBSD.ORG Fri Jul 27 08:21:32 2007 Return-Path: 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 474BC16A418 for ; Fri, 27 Jul 2007 08:21:32 +0000 (UTC) (envelope-from zbigniew@szalbot.homedns.org) Received: from szalbot.homedns.org (lists.lc-words.com [83.19.156.210]) by mx1.freebsd.org (Postfix) with ESMTP id F3CD013C467 for ; Fri, 27 Jul 2007 08:21:31 +0000 (UTC) (envelope-from zbigniew@szalbot.homedns.org) Received: from www (helo=www) by szalbot.homedns.org with local ; Fri, 27 Jul 2007 10:21:28 +0200 To: Manolis Kiagias X-PHP-Script: https://poczta.szalbot.homedns.org/index.php for 192.168.11.1 MIME-Version: 1.0 Date: Fri, 27 Jul 2007 10:21:28 +0200 From: Zbigniew Szalbot In-Reply-To: <46A9A792.3000805@otenet.gr> References: <46A9A792.3000805@otenet.gr> Message-ID: X-Sender: zbigniew@szalbot.homedns.org User-Agent: RoundCube Webmail/0.1b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit Cc: Freebsd questions 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 27 Jul 2007 08:21:32 -0000 Hello, On Fri, 27 Jul 2007 11:06:42 +0300, Manolis Kiagias wrote: > 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. Yes, indeed I now know what happened. The *-server version got upgraded and I was unaware that *-client stayed at 0.27. I was sure that upgrading *-server will upgrade *-client too. Apparently it did not happen: $ pkg_info -Ix mysql mysql-client-5.0.27 Multithreaded SQL database (client) mysql-server-5.0.45 Multithreaded SQL database (server) I guess this is something I can fix by setting appropriate option in pkgtools.conf? Thanks for your explanation! -- Zbigniew Szalbot