1

I am suddenly receiving the message, "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.

I'm running 5.26.1

How will this affect my Wordpress site?

Thank, dt

4
  • Can you run show table status where engine like '%ISAM%'; on your database, e.g. using phpmyadmin or command line? It will tell you what tables it's talking about.
    – Demerit
    Aug 18, 2020 at 18:03
  • 1
    Thanks so much Demerit! Turns out the tables in question are from the CiviElection extension. I've decided not to use that extension in favor of a WP plugin, so will delete that extension and see if message goes away. Aug 18, 2020 at 18:36
  • That did it. All is well. (For now) Thanks again. Aug 18, 2020 at 18:40
  • Ok cool. It's unlikely that extension specifically creates MyISAM tables and more likely it just doesn't specify, so it's probably that the system default is set to MyISAM, e.g. show variables like 'default_storage_engine';
    – Demerit
    Aug 18, 2020 at 18:46

1 Answer 1

0

It happened to me too after upgrading from 5.52.3 to 5.60. This post showed how to fix the 5 temp tables in my system: CiviCRM still creates MyISAM tables which results in Warning It looked like this: mysql> alter table civicrm_temp_2281c543efe9ebaa8e9fd6331f53600d ENGINE=InnoDB; Query OK, 9274 rows affected (0.13 sec) Records: 9274 Duplicates: 0 Warnings: 0 I did that for each InnoDB table it found. Should I change the default_storage_engine global from InnoDB to ISAM?

1
  • Yes - I think it's a good idea to "change the default_storage_engine global from InnoDB to ISAM?" Also - your default charset should be utf8mb4 (not sure if that is relevant, just mentioning it)
    – eileen
    Apr 21, 2023 at 23:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.