Changing MYSQL Storage Engines


MYSQL Change Storage Engine

Every MYSQL tables uses a storage engine. By default, MYISAM is the default table. Howver, when you create a new table, you can set the engine to something other other than MYISAM, such as the popular option InnoDB. InnoDB makes it safe to develope web applications without hangups; whereas MYISAM has limitations.

To change a table with mySQL console,
1) Type: ALTER TABLE tablename ENGINE = InnoDB;

To change a table with phpMyAdmin,
1) Open the database and select the table.
2) Select 'Operations'.
3) Change 'Storage Engine'
4) Select 'Go'.