Skip to main content
Drupal Answers

Return to Answer

replaced http://drupal.stackexchange.com/ with https://drupal.stackexchange.com/
Source Link
Community Bot
Community Bot
  • 1

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?How do I convert a database from MyISAM to InnoDB?

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?

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?

Source Link
mpdonadio ♦
mpdonadio ♦
  • 38.1k
  • 8
  • 89
  • 142

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?