CiviCRM Community Forums (archive)

I have Drupal 5.1 installed on my Shared Webhosted environment. It is working great. I was looking for some CRM support to the website I am developing. Drupal is on a CentOS Linux shared hosted with PHP and MySQL.

I downloaded the CiviCRM for Drupal (1. , installed in the Drupal's correct directory sites/all/modules and untared the file. I accessed the civicrm/install/index.php file to install.

It fails to install saying that MySQL must support innodb.

When I contact the webhosting company, they said innodb is not provided to MySQL on shared mode. For innodb support, I must upgrade my service to the Virtual Dedicated Server - which implies more $$/month.

I will appreciate if someone from CiviCRM community can answer the following questions:
- Is there any way I can get CiviCRM to work on regular myisam engine of MySQL?
- Drupal does not require innodb - why is innodb a must for CiviCRM?
- I am sure there are a lot of Drupal users out there who have same innodb problem with use of CiviCRM and not willing to spend extra $$/month for virtual server.
- Do you know any webhosting company that provides Drupal + CiviCRM on shared server (i.e. cheap)

Thanks for reading all this. Thanks in advance in anticipation of a reply.

My recommendation would be to move to a new shared host. Until today I've never had a problem with a shared host not allowing InnoDB. I ran into my first one today.

I can understand why you wouldn't want to go to VPS if you didn't need it - they can take more work than a shared host to administer and they cost quite a bit more. I went to a VPS recently only because I host a large number of sites and wanted more control over my hosting. But a VPS isn't right for everyone.