­
+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.

Cookies & Privacy Policy

Our website uses cookies to give you the best user experience on our website and to help us deliver our services. By using our services, you agree to our use of cookies. Click here for more information.
Necessary
Strictly necessary cookies help make a website navigable by activating basic functions such as page navigation and access to secure website areas. Without these cookies, the website would not be able to work properly.
Statistical
Statistical cookies help the website owner understand how visitors interact with the website by collecting and reporting information.
Marketing
Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and interesting to the individual user and thus more valuable for publishers and third-party advertisers.
Accept AllCustomizeAccept Necessary