Body: <p>I'm getting the MyISAM Database Engine error:</p>
  
  <blockquote>
    <p>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.</p>
  </blockquote>
  
  <p>However I'm using <a href="https://civihosting.com/" rel="nofollow noreferrer">CiviCRM Hosting</a> so I'm sure the MySQL database is configured correctly.</p>
  
  <p>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?</p>
  
  <p><a href="https://i.sstatic.net/qkcQ5.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/qkcQ5.png" alt="phpMyAdmin Table Listing"></a></p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-01-30T19:03:58.910Z
Comments.Text: See also: http://civicrm.stackexchange.com/questions/9177/myisam-database-but-all-civicrm-tables-are-innodb-is-this-a-problem?rq=1
Comments.UserDisplayName: Laryn
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-01T20:01:40.710Z
Comments.Text: 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.
Comments.UserDisplayName: George Lozier
Tags: <database><mysql>
Title: MyISAM Database Engine Error
ThreadText: # MyISAM Database Engine Error
  
  (Asked by: username_0 on 2016-01-30)
  
  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](https://civihosting.com/) 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](https://i.sstatic.net/qkcQ5.png)](https://i.sstatic.net/qkcQ5.png)
  
  **Tags:** database, mysql
  
  > **Comments:**
  > **username_1**: See also: http://civicrm.stackexchange.com/questions/9177/myisam-database-but-all-civicrm-tables-are-innodb-is-this-a-problem?rq=1  
  > **username_0**: 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.  
  
  ---
  
  ## 0 answers
  
  