How to safely upgrade mysql 4.0 to 4.1?

[vod]

Hi guys,

I would like to upgrade mysql 4.0.26 to mysql 4.1.21 however after several hours of researching i realised that the upgrade may likely to cause problems. From what i now the most common problem is the latin1 charset conversion to utf8. Besides that i think there are still some potential issues of such upgrade.

My server is running phpbb, cerberus helpdesk, openinvoice, and 1 customised php application

Anybody has done such upgrading? Any way to safely upgrade 4.0 to 4.1? What are the things i need to watch out for and what should i do to ensure a smooth upgrade?

Thank you very much. Your help is much appreciated.

 

[vod]

** bump **

Anyone?

 

[smtalk]

[COLOR=black]mkdir mysql
cd mysql
wget [/COLOR][URL="http://files.directadmin.com/services/all/mysql/MySQL-client-4.1.21-0.i386.rpm"][COLOR=black]http://files.directadmin.com/services/all/mysql/MySQL-client-4.1.21-0.i386.rpm[/COLOR][/URL]
[COLOR=black]wget [url]http://files.directadmin.com/services/all/mysql/MySQL-devel-4.1.21-0.i386.rpm[/url]
wget [url]http://files.directadmin.com/services/all/mysql/MySQL-server-4.1.21-0.i386.rpm[/url]
wget [url]http://files.directadmin.com/services/all/mysql/MySQL-shared-4.1.21-0.i386.rpm[/url]
rpm -Uvh MySQL-*-4.1.21-0.i386.rpm
/sbin/service mysqld restart[/COLOR]