MySQL with MyISAM engine worked!!

This is an open forum for any mojoPortal topics that don't fall into the other categories.

This thread is closed to new posts. You must sign in to post in the forums.

7/27/2010 7:40:23 AM

ugosweb

Total Posts 1

View Posts

MySQL with MyISAM engine worked!!

Hi,

I'm starting to use mojoPortal as my CMS. My hosting provider give me Windows Hosting and MySQL with MyISAM engine (it explicitely doesn't supply InnoDB).
The first attempt to start mojoPortal on that host failed because the setup tries to create InnoDB table.
I read some posts on this forum and it seems that mojoPortal needs InnoDB table necessarily because MyISAM is not transactional.
It sounded a little strange to me so in all the creation scripts under Setup/Applications I changed the string "InnoDB" to "MyISAM" and I run the setup again.
It worked!!! I played a little with mojoPortal in this configuration creating pages etc. and all seems to work correctly.

My questions are:

Are InnoDB and transactions really necessary for mojoPortal?

In this configuration are there some risks to loose something during normal usage of the portal?

Regards,

Ugo Chirico
http://www.ugochirico.com

7/27/2010 10:06:33 AM

Joe Audette

Total Posts 18439

View Posts

Re: MySQL with MyISAM engine worked!!

Hi Ugo,

I would not recommend doing that. Whether it will work ok I can't say for sure but it is not something I care to support for people to use different table types. I would just use a different host that supports innodb. At the very least it will be a hassle for you whenever upgrades add new tables.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.