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:
