Re: MySQL version upgrade [SOLVED]
[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 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
Re: MySQL version upgrade
On Fri, Jan 2, 2009 at 10:40 AM, Jos Chrispijn wrote: > I currently have running: > > mysql-client-4.0.27 & mysql-server-4.0.27, who I would like to upgrade to > mysql-client-5.0.75 & mysql-server-5.0.75 > > I can imagine that there is a database issue here as the 4.0 records might > differ from the 5.0 ones. > Is there a way of upgrading smoothly? I did upgrade my databases in advance. > > -- best Wishes for 2009 and thank you for your support in the last year. > ___ > freebsd-questions@freebsd.org mailing list 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 http://dev.mysql.com/doc/refman/5.0/en/upgrade.html and http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"