UnixServerAdmin

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

Advertisements

April 27, 2011 - Posted by | cPanel, MySQL | , ,

4 Comments »

  1. This is certainly a excellent article. Thanks for making the effort to describe all of this out for all of us. It is a great guide!

    Comment by Steffanie Ipock | June 15, 2011 | Reply

  2. This is certainly a amazing post. Many thanks for making the effort to detail all of this out for all of us. It really is a great help!

    Comment by Seema Thake | June 15, 2011 | Reply

  3. Please continue to publish on this matter. Generally there is a higher need than you may expect for this kind of advice and guidance. Everything you share is valuable to the person who wants the concepts that you’ve come up with.

    Comment by fresh water | June 15, 2011 | Reply

  4. I’ve been looking for specifically these details. While I was intending to locate this content I am really surprised that your particular article was so easy to locate and how it perfectly compared to my very own experience.

    Comment by amazing water filter | June 16, 2011 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: