From: Todd Lyons
Date: December 5 2007 8:42pm
Subject: Re: Determining Table Storage Engine Type on Crashed Table
List-Archive: http://lists.mysql.com/mysql/210351
Message-Id: <20071205204220.GC14475@ivenue.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; x-action=pgp-signed

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sun, Dec 02, 2007 at 09:55:23AM +0530, Alex Arul Lurthu wrote:

>How about looking at the .frm file of the table.

A couple of quickie tests shows something promising:

  strings table.frm | egrep 'MyISAM|InnoDB|engineA|engineB|etc'

Unknonwn whether other engines obey the same rules and methods.
- -- 
Regards...		Todd
Chris: grep 500 sendmail.mc 
undefine(`FAIL_MAIL_OVER_500_MILES')dnl
Chris: just in case ...
Linux kernel 2.6.22-14-generic   3 users,  load average: 0.00, 0.00, 0.00
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHVw0rY2VBGxIDMLwRAgXTAJwJnbs7jSnXmEezsOhpfHZeITcTegCfYfhh
LIv3YNplxWpzYjvluTeTKyk=
=XdMs
-----END PGP SIGNATURE-----