mysql install problems.

[Derrick MacPherson]

Trying to upgrade mysql from 40 to 50 on a 5.4 system. The client will 
update, but when I go to update the server, I get the following error. I 
was able to use pkg_add get 5.0.2 installed so at least it's 
functioning. I've tried to reinstall 40, and then deinstall, but it 
doesn't seem to help. What can I do?

===>  mysql-server-5.0.18_1 cannot install: the port wants 
mysql50-client and you try to install mysql40-client..
*** Error code 1

Stop in /usr/ports/databases/mysql50-server.

pkg_info |grep sql
bsdpan-DBD-mysql-2.9008 DBD::mysql - MySQL driver for the Perl5 Database 
Interface
courier-authlib-mysql-0.57 MySQL support for the Courier authentication 
library
exim-mysql-4.60     High performance MTA for Unix systems on the Internet
mysql-client-5.0.18_1 Multithreaded SQL database (client)
mysql-server-5.0.2  Multithreaded SQL database (server)
php4-mysql-4.4.1_3  The mysql shared extension for php
proftpd-mysql-1.2.10_1 Highly configurable ftp daemon with MySQL support