Topic: MYSQL 5X on SME7.4 server

[edb]

Has anyone upgraded their SME7.4 server to mysql 5.x?
If so, could you let me know how to do it without breaking Horde or anything else.
I need to upgrade to mysql 5x soon as a minimum software requirement for an application I'm running so any input would be much appreciated.

Thanks

edb

[chris burnat]

Moved to General Discussions - a more appropriate section of the forum for non-core issues.

[christian]

I know some people have as a scan through 7.4 upgrade issues points to people struggling with upgrades because of it.

I'm not fan of upgrading SME core components in this way as it tends to really complicate your life. In this case you would have to be comfortable with all of the SME apps moving forward then having to roll them back to mysql4 before doing your next upgrade.

What I have done in this situation is use VMWare to run a mysql5 database for whatever app needs it and then have my app point to that instead even if I run it on the SME itself.

When we get to SME 8 then you can do a backup/restore of the database from your VM to the base SME to consolidate your database if you wish.

That's my advice for what it's worth.

[edb]

Hi christian,

Thanks for your input on this topic and I do agree that it could cause complications down the road. I never really thought of using vmware to host a Mysql 5x database but that is not a bad idea at all and thanks for pointing that option out to me.

I have SME8beta3 running in Vmware right now but I can't wait for the stable release to appear for production use as it uses Mysql5.x and PHP 5.x.

Thanks again!

edb

[Boris]

I use to have also TomCat running directly on SME, that was not convenient to maintain, updates etc...
Now its running on preconfigured (of the shelf) VM appliance together with its own MySQL server and life is much easier.
Very good advice from edb.