Skip to main content
2 of 2
replaced http://drupal.stackexchange.com/ with https://drupal.stackexchange.com/

The easiest way is to take a backup with Backup and Migrate, open it in an editor and search/replace "MyISAM" to "InnoDB". Then restore it.

Personally, I would restore to a new catalog, and then switch the database in settings.php. This way, you can test before making the new version live.

Otherwise, this is a dup of How do I convert a database from MyISAM to InnoDB?

mpdonadio
  • 38.1k
  • 8
  • 89
  • 142