+# This is an example script that finds MyISAM tables in a database 

+# and converts them InnoDB. It assumes the user has passwordless 

+# access to the database.

+

+# Store the database name

+db_name=testdb

+

+# Store any MyISAM tables in an array

+readarray -t myisam_tables < <(mysql --skip-column-names --batch --execute "SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = '$db_name' AND ENGINE = 'MyISAM'")

+

+# Check if the array contains items, and if so convert the tables

+if [ "${#myisam_tables[@]}" -ge 1 ]; then

+  for table in "${myisam_tables[@]}"; do

+    mysql "$db_name" --execute "ALTER TABLE $table ENGINE = 'InnoDB'"

+  done

+else

+  echo "No MyISAM tables found in database $db_name"