Text* Snippets: myisam code

Never been to TextSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

About this user

Jamie Wilkinson http://tramchase.com

« Newer Snippets

Older Snippets »

1 total XML / RSS feed

Convert MySQL tables to InnoDB

// Slower than MyISAM, but row locking is clutch if you're doing a lot of writes amirite?

for t in $(mysql --batch --column-names=false -e "show tables" mydbname |grep -v "exclude_this");
do
mysql -e "alter table $t type=InnoDB" mydbname;
done

From:
http://ludo.qix.it/archive/2005/04/convert-a-bunch-of-tables-to-innodb.html

to mysql bash database db innodb myisam by jamiew on Nov 19, 2007