Skip to content

Instantly share code, notes, and snippets.

@d3zorg

d3zorg/convert mysql engine.sql

Created January 31, 2013 19:25
Show Gist options
  • Save d3zorg/4685621 to your computer and use it in GitHub Desktop.
Save d3zorg/4685621 to your computer and use it in GitHub Desktop.
Download ZIP
Convert from MySQL MyISAM to InnoDB tables
Raw
convert mysql engine.sql
SELECT CONCAT('ALTER TABLE ', table_name, ' ENGINE=InnoDB;') as ExecuteTheseSQLCommands
FROM information_schema.tables WHERE table_schema = 'name_of_your_db'
ORDER BY table_name DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment