From owner-freebsd-questions@FreeBSD.ORG Fri Jan 2 17:13:24 2009 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 715B7106566B for ; Fri, 2 Jan 2009 17:13:24 +0000 (UTC) (envelope-from kernel@webrz.net) Received: from webrz.xs4all.nl (webrz.xs4all.nl [82.95.248.216]) by mx1.freebsd.org (Postfix) with ESMTP id E938D8FC1D for ; Fri, 2 Jan 2009 17:13:23 +0000 (UTC) (envelope-from kernel@webrz.net) Received: from webrz.xs4all.nl (localhost [127.0.0.1]) by webrz.xs4all.nl (Postfix) with ESMTP id 9CDA65086A; Fri, 2 Jan 2009 18:13:24 +0100 (CET) Received: from [10.10.10.27] (protometheus.webrz.net [10.10.10.27]) by webrz.xs4all.nl (Postfix) with ESMTP id 4032250866; Fri, 2 Jan 2009 18:13:24 +0100 (CET) Message-ID: <495E4B32.10203@webrz.net> Date: Fri, 02 Jan 2009 18:13:22 +0100 From: Jos Chrispijn Organization: Koudekerke (NL) User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: APseudoUtopia References: <495E3551.40507@webrz.net> <27ade5280901020804l6bb8e89ehdcccc670634babb3@mail.gmail.com> In-Reply-To: <27ade5280901020804l6bb8e89ehdcccc670634babb3@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AV-Checked: ClamAV using ClamSMTP @triton.webrz.net Cc: freebsd-questions@freebsd.org Subject: Re: MySQL version upgrade [SOLVED] 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, 02 Jan 2009 17:13:24 -0000 [APseudoUtopia] Uit een eerder bericht van 2-1-2009 17:04 :: > I'd recommend that you read up on the MySQL documentation on the > subject of upgrading. > I don't mean to be mean, but it's not exactly a FreeBSD issue :-P I ofcourse was referring to the ports part of the whole story, sorry for not being clear about this. What I did: - Upgrade the MySQL client port and its dependencies first. - Upgraded mysql-client %> portupgrade -o databases/mysql50-client -f mysql-client-\* - Upgrade mysql-server %> portupgrade -o databases/mysql50-server -f mysql-server-\* - Recompiled everything else that depends on mysql-client so that they all link against the upgraded shlib: %> portupgrade -Nfi -r mysql-client-\* -x mysql-client -x mysql-server - Restarted my mysql-server and ran the mysql-upgrade program: %> mysql_upgrade -v -b /usr/local -d /var/db/mysql -u root Then I checked /var/db/mysql/mysite.err to see if there were any obvious problems (...): 090102 17:58:45 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run So I did a fix on my SQL tables: %> mysql_fix_privilege_tables --password=my_password mysite.err: 090102 18:07:39 mysqld started 090102 18:07:39 InnoDB: Started; log sequence number 0 2232580 090102 18:07:39 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.75' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.75 After this I tested all mysql client programs and am happy again :-) -- Jos Chrispijn