Skip to content

Instantly share code, notes, and snippets.

@rgo

rgo/gist:1714339

Created February 1, 2012 01:14
Show Gist options
  • Save rgo/1714339 to your computer and use it in GitHub Desktop.
Save rgo/1714339 to your computer and use it in GitHub Desktop.
Download ZIP
Convert MyISAM tables to InnoDB
Raw
gistfile1.sh
## Copied from: http://technotes.twosmallcoins.com/?p=356
# Get table listing and generate ALTER sql file
$ mysql -u foobar -p -e "show tables in <database> ;" | tail --lines=+2 | xargs -i echo "ALTER TABLE {} ENGINE=INNODB;" > alter_table.sql
# Execute ALTER sql queries generated to convert from MyISAM to InnoDB:
$ mysql -u foobar -p <database> < alter_table.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment