Migration from MySQL 3.23 to MySQL 5
Posted by: laurent laurent
Date: November 24, 2011 04:32AM


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 ?

Options: ReplyQuote

Written By
Migration from MySQL 3.23 to MySQL 5
November 24, 2011 04:32AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.