Never been to CodeSnippets 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

2 total

On This Page:

  1. 1 Bulk convert InnoDB tables to MyISAM
  2. 2 Convert MySQL tables to InnoDB

Bulk convert InnoDB tables to MyISAM

to mysql sql innodb myisam convert by jamiew on Apr 02, 2008 1 Comments
// produces some handy ALTER statements
// I think there's a way to this w/ mysqladmin but I couldn't find it.

SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' engine=MyISAM;') FROM information_schema.tables WHERE engine = 'InnoDB';

Convert MySQL tables to InnoDB

to mysql bash database db innodb myisam by jamiew on Nov 19, 2007
// 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
2 total

On This Page:

  1. 1 Bulk convert InnoDB tables to MyISAM
  2. 2 Convert MySQL tables to InnoDB