Determine which storage type is used by a MySQL table

To determine which storage type (e.g. MyISAM, InnoDB) is being used by a table, use the mysqlshow command:

mysqlshow -i -u[username] -p [database]

Only use the -u and -p flags if you need to specify a username and enter a password to access the database.

Last modified: 10/06/08 16:48:52
Go to top

Related Pages

No related pages or links.

Login/out

Login

Forgot Password?
Go to top
Go to top