Bug #8276

Default storage engine not always right on mySql

Details

Request #8276	Default storage engine not always right on mySql
Submitted	2006-07-24 16:10 UTC
From	jo at durchholz dot org
Status	Bogus
Package	MDB2
PHP Version	Irrelevant
OS	Irrelevant
Roadmaps	(Not assigned)

Comments

[2006-07-24 16:10 UTC] jo at durchholz dot org

Description:
------------
The mySql driver in MDB2 assumes a default storage engine of INNODB. Unfortunately, it's not installed in several cases. I hit that issue in:
* xampp 1.5.1 (thats actually a fairly recent version)
* SuSE Linux 9.1 as installed on 1&1 rootservers
IMHO it would be better if MDB2 used whatever storage engine is the current default in the mySql database. The programmer could still force a specific engine if desired (actually we'll need transactions in one of our next projects, and will use InnoDB for that).

(Don't bother if this was changed from 2.1 to 2.2; we're actually on 2.1, but an upgrade would take a day and we're too far behind schedule right now. I'll reexamine the issue for 2.2 when I have the time.)

Test script:
---------------
$_db_xml_prefixes =
array (
'db' => 'fwtest',
'mp' => 'fw_cmn_album',
'p' => 'fw_'
);
$schema =& MDB2_Schema::factory ($_db);
$schema->updateDatabase ('db.xml', false, $_db_xml_prefixes);