How to change the storage engine type on MySQL?

mysql

Solution

The following article will tell you how to set the default storage engine, how to explicitly use a specific engine during a CREATE TABLE command, and how to change the storage engine of existing tables:

http://dev.mysql.com/doc/refman/5.1/en/storage-engine-setting.html

Problem

I would like to use InnoDB as the storage engine on all my tables and databases. Is there a command I can run to change the type of my current tables to use InnoDB instead of MyISAM? Also, is there a way to set this as the default so I don't have to do this again?

Original source