Introduction
Occasionally someone wants to convert the database tables to MyISAM. There isn't a simple way of doing the conversion and preferably should be performed by a qualified server administrator.
Procedure
The MySQL database can be dumped into a SQL file using mysqldump followed by replacing "ENGINE=INNODB" with "ENGINE=MyISAM". Then the database can be dropped (deleted), recreated and the SQL dump that is modified can be restored.
This is an example if the database name was user_db:
mysqldump user_db > user_db.sql
sed -i 's/ENGINE\=InnoDB/ENGINE\=MyISAM/g' ./user_db.sql
Then drop the user_db database and recreate it again.
Then import the sql dump
mysql user_db < ./user_db.sql