CiviCRM Community Forums (archive)

Hi,

Apologies in advance for the newbie question...

I know CiviCRM requires InnoDB, and I have that working OK.  But it would be easier for me to run Drupal using MyISAM, since that's the default storage engine in my shared host's MySQL configuration.  Is it OK to use a MyISAM database for Drupal and an InnoDB database for CiviCRM, or do they both have to use InnoDB?

Thanks,
Andrea

Greetings folks.

I am new to this CiviCRM stuff (bet you never heard that before). 

I installed 2.1 on Joomla 1.5 without a hitch.  --  Very Nice

My site(s) are being hosted on servers that use MyISAM as the default table engine.
I have tried running ALTER TABLE {tablenamehere} ENGINE=InnoDB; against the CiviCRM tables,
(one at a time mind you).       And get a success message when it completes.  Yet, when I
go back to look at the table structure, it still shows MyISAM as the table engine.   

If I cannot get these tables converted, would this be a show stopper, or is this the most perferred
table engine for CiviCRM?

Thanks a BUNCH!

My site(s) are being hosted on servers that use MyISAM as the default table engine.
I have tried running ALTER TABLE {tablenamehere} ENGINE=InnoDB; against the CiviCRM tables,
(one at a time mind you).       And get a success message when it completes.  Yet, when I
go back to look at the table structure, it still shows MyISAM as the table engine.   

Does it show MyISAM for the tables you’ve converted, or just as the default engine for the database?

(I’m pretty sure we do create our tables as InnoDB, so if it was supported by your MySQL install then the tables would be already InnoDB.) :|