MySQL administration: convert MyISAM tables to InnoDB

mysql-convert-myisam-to-innodb.sh

#!/bin/bash

sql_list="select table_schema, table_name from information_schema.tables where lower(engine) = 'myisam' and table_schema not in ('mysql', 'information_schema', 'performance_schema') order by data_length;"

mysql --batch --silent -e "$sql_list" |while read -r d t; do
  printf "\n---\n$d.$t "
  mysql --batch --silent -e "select (data_length+index_length)/1e6 from information_schema.tables where table_schema='$d' and table_name='$t';"
  time mysql --batch --silent -e "alter table $d.$t engine='innodb';"
done