zapbrannigan

Hi, sorry if this question has been asked before - I tried to search but haven't came up with a question that matches mine (I think). I have a server that runs MySql 4.1 and php 4.11 with Apache 2 from FC1 RPMS. Its been fine till now, however I have the need for the stored procedures and triggers that MySQL 5 offers. Firstly, is there any way to upgrade to MySQL 5 and leave php 4.11 as it is, and use the new features of MySQL 5 through regular SQL statements executed from php (i.e. mysql_query())? Secondly, is there any way to upgrade to MySQL 5 and PHP 5 using just a yum RPM type upgrade? Is it possible to use the RPMS from the fedora dev? I already have php 4.11 and mysql 4.1 working with apache 2 - just would like to upgrade them... A slight problem I have doing this is the server is live, and ideally I don't want any interruptions to the service for more than say 4 hours (I'll have to do this at 2 to 3am....  ::))