convert LIVE mysql tables from MyISAM to InnoDB via mysql cli

myisam2innodb.sh

#!/usr/bin/env bash
#
# This was commented on the following page: 
# https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
#
# This script/command was tested and found to be harmless/non-destructive, surprisingly. ;-P
# 
DBNAME="exampledb";
DBHOST="localhost";
DBUSER="someguy";

mysql -h ${DBHOST} -u ${DBUSER} -p ${DBNAME} -e "show table status where Engine='MyISAM';" | awk 'NR>1 {print "ALTER TABLE "$1" ENGINE = InnoDB;"}' | mysql -h ${DBHOST} -u ${DBUSER} -p ${DBNAME};