PDA

View Full Version : Upgrade of MYSQL ??


photocroatia
13th of March 2007 (Tue), 00:18
I need to upgrade MYSQL, does anybody know how to do this or can you recommend someone?

I am currently running mysql 3.23.58 and would liek to upgrade to mysql 4.2.??

Is there a recommended version? I know 5 is out, but I hear there are some code differences introduced in 5, is this correct?

I have my own dedicated hosting server.

Thank you

Pekka
13th of March 2007 (Tue), 15:49
EE does not use any extra features in 5.x but still it is a good idea to go up 5.0 because it will make your subsequent MySQL upgrades easier. EE 2 is optimized for both 4 and 5 and both work equally ok. But you must also check all other programs you use that they work with 5.

Upgrading should be done exactly as instructed in http://dev.mysql.com/doc/refman/5.0/en/upgrade.html

PS. Upgrading MySQL sequentially is time-consuming, one option is to back up your databases and uninstall MySQL, install full 5.0, make the databases, make privileges and dump tables back.

photocroatia
14th of March 2007 (Wed), 17:43
Thank you Pekka,

Can EE 1.5 RC 2 run on MYSQL 5?

Should I upgrade EE first to V2 or should I upgrade MYSQL first to V5

Thank you.