You need to use this command for checking the engine type:
SHOW TABLE STATUS WHERE Name = ‘users’;
Or Use this command for checking the all table’s engine type.
SHOW TABLE STATUS;
Or You can use this command for database:
mysqlshow –status db_name;
I used following URL for creating this commands:
http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html
5 
SHOW TABLE STATUS WHERE Name = 'xxx'
Incoming search terms:
- mysql check database engine
- how to find the mysql database engine type
- mysql database type for wordpress
- mysql database type wordpress
- mysql show database engine
- mysql show databases engine type
- wordpress mysql connect wp engine
- wp mysql engine type
- wp themes for database type
Pingback: uberVU - social comments