Re: DBI/DBD::mysql: Detecting InnoDB?
- From: luke@xxxxxxxxxxxxxxx
- Date: Mon, 14 Nov 2005 08:33:02 +1030
Hi.
13Nov2005 @ 13:04 Tyler MacDonald thusly spake
> Hello,
>
> I'm working on a database package right now that will support
> multiple backend drivers (currently just DBD::Pg and DBD::mysql, possibly
> more in the future). With MySQL, you can only support transactions and
> foreign keys if you have enabled the InnoDB database backend. This would
> undoubtedly mean that you would want to use a different database schema
> depending on whether InnoDB is available.
>
> Is there a clean way to detect whether InnoDB support is available
> on the MySQL server? The best I've been able to come up with so far, is
> attempting to create a temporary table with the "TYPE=InnoDB" argument and
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.
Also the command from the mysql prompt.
mysql> 'show table status;'
shows table types.
hth.
Kind regards.
Luke
> testing to see if it fails, but if there is just some flag I can query the
> database with I would much rather use that.
>
> Thanks in advance,
> Tyler
>
--
.............._..
..| .| |.|/.|_ .
..|__.|_|.|\.|_ .
:61 421 276 282:
.
- Follow-Ups:
- Re: DBI/DBD::mysql: Detecting InnoDB?
- From: Tyler MacDonald
- Re: DBI/DBD::mysql: Detecting InnoDB?
- References:
- DBI/DBD::mysql: Detecting InnoDB?
- From: Tyler MacDonald
- DBI/DBD::mysql: Detecting InnoDB?
- Prev by Date: DBD::Oracle won't install for Oracle 10G XE
- Next by Date: Re: DBI/DBD::mysql: Detecting InnoDB?
- Previous by thread: DBI/DBD::mysql: Detecting InnoDB?
- Next by thread: Re: DBI/DBD::mysql: Detecting InnoDB?
- Index(es):
Relevant Pages
|
|
