Migration from MySQL 3.23 to MySQL 5

[laurent laurent]

Hello,

I am for a few webmaster for an ecommerce site. The database is on a 3.23 MySQL server (yes, it still exists, with PHP4...) and I would like to migrate to an updated version. I am here to know if other people already did it, keeping in mind that the site can be down for 5 min max.

The problems I saw are :
- the PASSWORD function has been updated, I have to remplace it with OLD_PASSWORD
- encoding was latin1, it would be better to convert it to UTF8 with mysqldump

I am planning to :
- prepare a new MySQL 5 server with according configuration
- put down the website
- export and import into the new database with needed conversion
- update the php configuration and authentification process
- put up the website

I m still wondering if I forgot something or if there is a better way to do it ?