List:General Discussion« Previous MessageNext Message »
From:Todd Lyons Date:December 5 2007 8:42pm
Subject:Re: Determining Table Storage Engine Type on Crashed Table
View as plain text  
-----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-----
Thread
Determining Table Storage Engine Type on Crashed TableRichard Edward Horner21 Nov
  • Re: Determining Table Storage Engine Type on Crashed TableMicah Stevens22 Nov
    • Re: Determining Table Storage Engine Type on Crashed TableRichard Edward Horner23 Nov
  • Re: Determining Table Storage Engine Type on Crashed TablePaul McCullagh23 Nov
    • Re: Determining Table Storage Engine Type on Crashed TableRichard Edward Horner23 Nov
    • Re: Determining Table Storage Engine Type on Crashed TableRichard Edward Horner28 Nov
      • Re: Determining Table Storage Engine Type on Crashed TableWm Mussatto28 Nov
      • Re: Determining Table Storage Engine Type on Crashed TableAlex Arul Lurthu2 Dec
        • Re: Determining Table Storage Engine Type on Crashed TableTodd Lyons5 Dec