for x in $(echo "show tables;"| mysql --user=fartman --password=beer --host=10.11.12.13 --database=pet|grep -v Tables_in); do echo "alter table $x engine = innodb;" | mysql --user=fartman --password=beer --host=10.11.12.13 --database=pet;done
or:
http://www.linux.com/articles/46370
Showing posts with label mysql convert all tables from myisam to innodb. Show all posts
Showing posts with label mysql convert all tables from myisam to innodb. Show all posts
Friday, January 30, 2009
Subscribe to:
Posts (Atom)