Convert Magento MyISAM Tables to InnoDB

At some point it become handy to not have MyISAM tables in your Magento database.

Here is a simple procedure to determine which tables need to be converted

SET @DATABASE_NAME = 'The_Name_Of_Your_DB';

SELECT CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements FROM information_schema.tables AS tb WHERE table_schema = @DATABASE_NAME AND `ENGINE` = 'MyISAM' AND `TABLE_TYPE` = 'BASE TABLE' ORDER BY table_name DESC;

You can contact [email protected] or find him updating post at http://magento.stackexchange.com/

Find lots of fun stuff https://github.com/brentwpeterson

Leave a Reply

Sorry, you must be logged in to post a comment.