Server Administration & Management

How to check database engine in MySQL

If you wish to check, which database engin is used by your database i.e is it using MyISAM or InnoDb

There are two ways to check database engine one is thruogh phpmyadmin and other is through shell.

Method -1 :- By PhpMyAdmin

a) Login to cpanel
b) Go to PhpMyAdminm
c) select database

Method -2 :- By Shell

Under structure Tab you will see colum name Type which indicates your current database engine.

a) Login to server shell as root and execute following command.

# mysqlshow –status databasename

April 27, 2011 Posted by | cPanel, MySQL | , , | 4 Comments