[MySQL]: SQL script to list MyISAM & innodb_file_per_tables

April 6, 2015 · by · in MySQL

— It needs to be run from an account that has read permission for the INFORMATION_SCHEMA database. select msg as `==> Checking current version of MySQL.` from ( select ‘This script should be run on MySQL version 5.6. ‘ +…