MySQL 4.0->4.1 upgrade advice

[itsensellc]

Hi,

I've already read forum posts here and the general stuff on MySQL's website about upgrading 4.0 to 4.1. I have questions that pertain more to my scenario though and would like some advice please!

1> I'm running MySQL 4.0.16 in "new" mode right now. I've had no complaints so far. So does this mean I'm likely in the clear as far as major troubles?

2> I'm not worried about data so much because I plan on doing a MySQL dump on everything before hand. But I am worried about privileges. Is there any way to make sure I don't lose privileges? This password change deal kind of scares me.

3> I'm really confused on the PHP side of the house when it comes to traditional MySQL versus MySQLi. I have people running things like PHPBB and other COTS applications and don't want those to break. I've read a bit about compiling PHP with both but nothing has been concise to say it works.

4> Any way to redirect ALL websites on the server to a maintenance page easily?

Thanks for any advice!

 

[jmstacey]

1. Most likely, but not always

2. Configure MySQL to use the old passwords. Doing this creates two options in phpMyAdmin when modifying a password. Select boxes to save it in either now or old format.

3. MySQL and MySQLi are different backends
The only common thing between the two are the SQL syntax.
PHP will need to be recompiled for the new version however script compatibility relies on the script itself and compatibility is made possible by the script writers/maintainers.

4. Not easily. Best notify all your resellers and users beforehand of the scheduled downtime.

This may help:
http://www.directadmin.com/features.php?id=466