mysql -u mysql_user -pXXXXXX -e “SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = ‘database_name'”