How to install Drupal with MyIsam instead of InnoDb and with utf8_unicode_ci collation?
I know there are ways to change/convert both afterwards, but maybe its possible to specify it as installation parameter - it would be simpler.
Drupal Answers is a question and answer site for Drupal developers and administrators. It only takes a minute to sign up.Sign up to join this community
You can do during the installation or you can convert
// Provide defaults if needed. $table += array( 'mysql_engine' => 'MyISAM', //Changed from Innodb to MyISAM 'mysql_character_set' => 'utf8', mysql_collation' => 'utf8_unicode_ci', //Added the collation ); $sql .= 'ENGINE = ' . $table['mysql_engine'] . ' DEFAULT CHARACTER SET ' . $table['mysql_character_set'] . ' COLLATE ' . $table['mysql_collation'];
in case you want to convert already created tables. put the site on maintenance mode and use phpmyadmin to convert the engines and collations