Return to Snippet

Revision: 10815
at January 14, 2009 13:42 by rowntreerob


Initial Code
mysql -u root snappsv2tst -e "show table status \G;"  | grep 'Name:' | sed 's/^\(.*\)/ALTER TABLE \1/' snappsv2_engine_alter.sql | sed 's/$/ ENGINE=INNODB;/' > snappsv2_engine_alter.sql

mysql -u root dbname < snappsv2_engine_alter.sql

Initial URL


Initial Description


Initial Title
convert mysql engine to innodb

Initial Tags
mysql

Initial Language
Bash