Skip to content

Instantly share code, notes, and snippets.

@piscis

piscis/gist:1324540

Created October 29, 2011 14:51
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save piscis/1324540 to your computer and use it in GitHub Desktop.
Save piscis/1324540 to your computer and use it in GitHub Desktop.
Download ZIP
handy little bash innodb table converter
Raw
gistfile1.sh
for t in $(mysql --batch --column-names=false -e "show tables" dbname |grep -v "exclude_this");
do
mysql -e "alter table $t engine=InnoDB" dbname;
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment