CiviCRM Community Forums (archive)

I've just pestered and hounded the company that hosts my sites to enable innoDB. The just plain won't do it. They claim to have had too many issues with it and decided not to support it. They won't budge.

Is there any way CiviCRM will run on a server without innoDB enabled for MySQL?

Or do I have to start looking for another provider?

(I really hope not becuase the service with these guys is great)

We use transactions and other features of innoDB. so innoDB is a requirement. We will probably add a check and warning when folks visit the civicrm admin page if we detect missing innoDB support in a future version. I've seen a few civicrm databases which were in bad shape because they were MyISAM (and hence rollbacks were not performed in case of failure etc)

The hosting provider page is community contributed, can you please update it for other folks benefit

lobo

If you have access to the command line the following command will do the trick:

$ echo "show variables like 'have_innodb'" | mysql -uUSER -pPASS DBNAME
Variable_name   Value
have_innodb     YES

if you dont have shell access, install PhpMyAdmin and check the documentation there

lobo