Date: Fri, 02 Jan 2009 18:13:22 +0100 From: Jos Chrispijn <kernel@webrz.net> To: APseudoUtopia <apseudoutopia@gmail.com> Cc: freebsd-questions@freebsd.org Subject: Re: MySQL version upgrade [SOLVED] Message-ID: <495E4B32.10203@webrz.net> In-Reply-To: <27ade5280901020804l6bb8e89ehdcccc670634babb3@mail.gmail.com> References: <495E3551.40507@webrz.net> <27ade5280901020804l6bb8e89ehdcccc670634babb3@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
[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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?495E4B32.10203>