MySQL version upgrade

[APseudoUtopia]

On Fri, Jan 2, 2009 at 10:40 AM, Jos Chrispijn <kernel at webrz.net> 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 at 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