Re: DBI/DBD::mysql: Detecting InnoDB?

luke@xxxxxxxxxxxxxxx <luke@xxxxxxxxxxxxxxx> wrote:
> You could try the 'mysqladmin -u <user> -p<passw> -V'
> If your version of mysql is later than 3.23.6 it will support InnoDB.

Unless the "skip-innodb" option is enabled in their conf file. Also,
this requires that the user not only have DBD::mysql installed, but have
mysqladmin installed as well.

> mysql> 'show table status;'

Yes, but only if you've already created an InnoDB table. :-/

I guess that leaves me with attempting to create a temporary table,
and if that fails, assuming it's turned off... Unless, is there any perl/DBI
way for me to interrogate the MySQL server to determine what version it is,
and whether or not "skip-innodb" has been turned on?

Thanks,
Tyler

.

Relevant Pages