How do you convert database tables from InnoDB to MyISAM?

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