Skip to content

Instantly share code, notes, and snippets.

@sokratisg

sokratisg/myisam_to_innodb.sql

Last active August 29, 2015 14:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sokratisg/7f1f3fc9f704b68d892b to your computer and use it in GitHub Desktop.
Save sokratisg/7f1f3fc9f704b68d892b to your computer and use it in GitHub Desktop.
Download ZIP
DDL for MyISAM to InnoDB conversion
Raw
myisam_to_innodb.sql
SELECT CONCAT('ALTER TABLE `',table_schema,'`.`',table_name,'` engine=InnoDB;') FROM information_schema.tables WHERE TABLE_SCHEMA='<MY_DATABASE>' AND ENGINE = 'MyISAM';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment