Berikut ini cara tercepat dan termudah untuk mengkonversi semua table MySQL type InnoDB menjadi MyISAM:
U=USERNAME;P=PASSWORD;D=DBNAME;
for t in $(mysql -u$U -p$P --skip-column-names $D -B -e 'SHOW TABLES');
do mysql -u$U -p$P $D -e "ALTER TABLE $t ENGINE=MyISAM";
done;
Ganti USERNAME, PASSWORD dan DBNAME sesuai akses MySQL anda.
PHPMYADMIN
Jika melalu PHPMyAdmin maka:
SET @DATABASE_NAME = 'bekasipo_drupal7';
SELECT CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements
FROM information_schema.tables AS tb
WHERE table_schema = @DATABASE_NAME AND `ENGINE` = 'MyISAM' AND `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC
Kemudian jalankan hasil command di atas di PHPMyAdmin lagi.