update or not update? MySQL 5

[jnarvaez]

Hi, i have a box with 400 domains, i was wondering if it would a good idea updating mysql from version 4 to 5.

Will be any incompatibility problem with my costumers applications?

What do you think?
Best regards.

 

[CBiLL]

Originally posted by jnarvaez
Hi, i have a box with 400 domains, i was wondering if it would a good idea updating mysql from version 4 to 5.

Will be any incompatibility problem with my costumers applications?

What do you think?
Best regards.

I was thinking the same thing until I got the answer I needed at http://forum.swsoft.com/showthread.php?s=&threadid=45483 so it may help you too.

Bill

 

[horosho]

Be aware that there was a change in join syntax as of MySQL 5.0.12. This may cause some problems as some queries that worked before will need to be rewritten. At the very least there will likely be some applications that need to be updated ( I would guess, seeing as you have 400 domains). I would use caution making this upgrade.
HTH

 

[jnarvaez]

I think i will make a full backup and restore then in a local server with mysql5 and php5 to test if all the sites work fine.

thank you for your help

 

[Amin Taheri]

its almost certain that at least a few sites will break, make sure you let the right people know before you do it, and always keep backups of customer data

you may need to fix tables after the upgrade as well