Top Nav

Convert MyISAM Tables to InnoDB

The command to convert a single table from MyISAM to InnoDB looks like:

This is described suscintly by Major.IO:

http://major.io/2007/10/03/convert-myisam-tables-to-innodb/

Kevin van Zonneveld goes further in his blog:

http://kvz.io/blog/2010/04/27/convert-all-tables-to-innodb-in-one-go/

and provides some scripts to convert all tables instead of doing one at a time.

I like the following:

This variation shows the table name before starting the conversion so I can see progress. The query output is pipped right back in to mysql to execute.

Email
Print