How to check whether a table is innoDB or myISAM

 
It is easy to check whether a table is innoDB or myISAM if you have phpMyAdmin access. Do the below steps if you’re on a cPanel server.

1. Log in to cPanel

Link to access cPanel : http://ServerIP:2082

2. Enter cPanel username and password to login

3. Click on “phpMyAdmin” under “Databases”

4. Click on Database name in phpMyAdmin and it will list all tables in the database

Under “Type” you can see whether the table is innoDB or myISAM. Check the below screnshot
 

 

You can also check the Engine of the table using the below commands

1. Log into linux server via SSH

2. Log in to mySQL

Run the below command to show the engine of all tables in mySQL database

mysql> SHOW TABLE STATUS FROM table_name;
 

 

OR

You can run the below command to check the engine of a single mySQL table

mysql> SHOW TABLE STATUS FROM `database_name` LIKE ‘table_name’;

Example: