Answers.Body: <p>Short answer: Change the storage engine of the table with the following command in mysql: </p>
  
  <p><code>ALTER TABLE log_civicrm_install_canary ENGINE=InnoDB</code></p>
  
  <p>The <code>civicrm_install_canary</code> is a table used for installation purposes. The purpose is explained in the answer on <a href="https://civicrm.stackexchange.com/questions/15594/what-is-the-installation-canary">What is the installation canary?</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-25T08:59:52.683Z
Answers.LastActivityDate: 2016-10-29T08:02:59.153Z
Answers.LastEditDate: 2017-04-13T12:53:13.017Z
Answers.UserDisplayName: Kainuk - CiviCooP
Body: <p>I getting the following error when I try to dump my civicrm drupal database</p>
  
  <blockquote>
    <p>Couldn't read status information for table log_civicrm_install_canary
    () mysqldump: Couldn't execute 'show create table
    <code>log_civicrm_install_canary</code>': Unknown storage engine 'ARCHIVE' (1286)</p>
  </blockquote>
  
  <p>This table is related to the civicrm logging feature as described in the article <a href="https://civicrm.org/blog/eileen/who-did-what-when" rel="nofollow">https://civicrm.org/blog/eileen/who-did-what-when</a>. Logging was enabled a while ago and everything seemed to work fine. Since then the site has been migrated to a new host and has had both civi and the drupal core updated a number of times. Currently, The site is hosted on omega8 running barracuda which is an aeger based host so these updates are more like site migrations. The instructions in the blog required turning on INNODB with a civicrmapi call. This was run for the original site but not on any of the migrated sites. I don't know if this is relevant? I am now getting the error when dumping the database via mysqldump. </p>
  
  <p>Does anyone have any idea what this table is for or what might be causing the error?</p>
  
  <p>Thanks for any help.</p>
  
Tags: <logging><mysql-archive-format><db-logging>
Title: CiviCRM logging enabled. I am now getting an error on mysqldump. Unknown storage engine 'ARCHIVE'
ThreadText: # CiviCRM logging enabled. I am now getting an error on mysqldump. Unknown storage engine 'ARCHIVE'
  
  (Asked by: username_0 on 2016-10-04)
  
  I getting the following error when I try to dump my civicrm drupal database
  
  > Couldn't read status information for table log\_civicrm\_install\_canary
  > () mysqldump: Couldn't execute 'show create table
  > `log_civicrm_install_canary`': Unknown storage engine 'ARCHIVE' (1286)
  
  This table is related to the civicrm logging feature as described in the article <https://civicrm.org/blog/eileen/who-did-what-when>. Logging was enabled a while ago and everything seemed to work fine. Since then the site has been migrated to a new host and has had both civi and the drupal core updated a number of times. Currently, The site is hosted on omega8 running barracuda which is an aeger based host so these updates are more like site migrations. The instructions in the blog required turning on INNODB with a civicrmapi call. This was run for the original site but not on any of the migrated sites. I don't know if this is relevant? I am now getting the error when dumping the database via mysqldump.
  
  Does anyone have any idea what this table is for or what might be causing the error?
  
  Thanks for any help.
  
  **Tags:** logging, mysql-archive-format, db-logging
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-10-25. Score: 1
  
  Short answer: Change the storage engine of the table with the following command in mysql:
  
  `ALTER TABLE log_civicrm_install_canary ENGINE=InnoDB`
  
  The `civicrm_install_canary` is a table used for installation purposes. The purpose is explained in the answer on [What is the installation canary?](https://civicrm.stackexchange.com/questions/15594/what-is-the-installation-canary)
  
  
  ---
  
  