Skip to content

Instantly share code, notes, and snippets.

@spin0us

spin0us/gist:11376298

Created April 28, 2014 15:58
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 spin0us/11376298 to your computer and use it in GitHub Desktop.
Save spin0us/11376298 to your computer and use it in GitHub Desktop.
Download ZIP
mMySQL : Convert all table from MyISAM to InnoDB
Raw
gistfile1.txt
SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' ENGINE=InnoDB;')
FROM information_schema.tables
WHERE table_schema NOT IN ('mysql','test','performance_schema','information_schema')
AND ENGINE='MyISAM'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment