Date: Fri, 27 Jul 2007 10:21:28 +0200 From: Zbigniew Szalbot <zbigniew@szalbot.homedns.org> To: Manolis Kiagias <sonicy@otenet.gr> Cc: Freebsd questions <freebsd-questions@freebsd.org> Subject: Re: mysql upgrade from 5.0.27 to 5.0.45 Message-ID: <adfc4789535aa87b3a7f5bb594d8c77c@szalbot.homedns.org> In-Reply-To: <46A9A792.3000805@otenet.gr> References: <46A9A792.3000805@otenet.gr>
next in thread | previous in thread | raw e-mail | index | archive | help
Hello, On Fri, 27 Jul 2007 11:06:42 +0300, Manolis Kiagias <sonicy@otenet.gr> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?adfc4789535aa87b3a7f5bb594d8c77c>