Experiences Upgrading MySQL

Before I go off and start messing up my server, does anyone who's personally upgraded a web server with mySQL from 4.0/4.1 to 5.0 have any tips to share? Were there any unexpected steps necessary to get things working again?

Is the RHEL 3 RPM an appropriate way to upgrade it on a CentOS 3.4 system?

Did Apache and PHP need to be recompiled to support the new version of mySQL?

All my servers have DirectAdmin which has a script to rebuild apache and PHP 4 with the latest copies from their site, but I've never run it. There's not much documentation on things like whether it overwrites the httpd.conf and php.ini files with default ones or not.

Thanks for any tips.

 

 

 

 

Top