Below is a small Bash script to crawl through all the tables in a
MySQL database and look for any and all MyISAM tables. We
developed this script when we realized that a team of developers
were ignoring our requests to create all tables as InnoDB. We set
the default storage engine to be InnoDB, however, the team would
declare the Storage Enginge to be MyISAM which caused MySQL to
ignore our default declaration.
Yes, we could run a "SHOW TABLE STATUS," but that would require staring at a lot of table entries in some databases. Naturally, we could also query the Information Schema database as well. All of those methods are fine. For our …