I'm getting the MyISAM Database Engine error:

Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in your database to InnoDB. Using MyISAM tables will result in data integrity issues.

However I'm using CiviCRM Hosting so I'm sure the MySQL database is configured correctly.

When I list my database using phpMyAdmin (see image) I see three tables that are MyISAM. These are a log and two temporary tables. Is this a problem? Should I try to fix this? Should I delete these tables?

phpMyAdmin Table Listing

  • 5
    See also: civicrm.stackexchange.com/questions/9177/…
    – Laryn
    Commented Jan 30, 2016 at 19:03
  • 1
    Thanks for the link. I use phpMyAdmin and the SQL command "ALTER TABLE civicrm_system_log ENGINE=InnoDB;". I also deleted the temporary tables. This fixed the problem. Commented Feb 1, 2016 at 20:01


Browse other questions tagged or ask your own question.