Find all MySQL databases using InnoDB engine
To find all MySQL database using InnoDB MySQL engine, run
1 |
mysql -N mysql -e "SELECT table_schema FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb';" | cut -d" " -f2 | sort | uniq |
To find all MySQL database using InnoDB MySQL engine, run
1 |
mysql -N mysql -e "SELECT table_schema FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb';" | cut -d" " -f2 | sort | uniq |