+1 (408) 320-0380

Converting MyISAM engine to InnoDB

Supporting MyISAM engine was dropped in EspoCRM v6.0+. All tables should be converted to InnoDB engine, otherwise some problems may occur.

This can be done by one of the following methods:

  1. Using the database tools such as phpMyAdmin, MySQL Workbench, etc.
  2. Using the pre-configured script.

Using the pre-configured script:

  1. Create a backup of your database, https://docs.espocrm.com/administration/backup-and-restore/#step-2-backup-database.
  2. Download https://www.espocrm.com/downloads/scripts/convert-myisam-to-innodb.zip, unzip and copy the script to your EspoCRM root directory.
  3. Run in CLI:
    php convert-myisam-to-innodb.php
  4. Remove the file after the script is executed.