MDB2 MySQL InnoDB & Transactions

Hi,

a stupid beginner question?: How do I configure MDB2 to be
able to use
transations with MySQL (using InnoDB)?


$config = array(
  'default_table_type' => 'INNODB'
);

$dbc = MDB2::singleton($mydsn, $config);


That's it ???

Will MDB2_Schema create all tables using InnoDB with that
configuration?

Is it possible to mix 'table drivers' using MDB2_Schema? I
guess no? :-(


Ok.. Thanks for any info!

Regards,
Matthias

-- 
PEAR Development Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php

Matthias Nothhaft wrote:
> Hi,
> 
> a stupid beginner question?: How do I configure MDB2 to
be able to use
> transations with MySQL (using InnoDB)?
> 
> 
> $config = array(
>   'default_table_type' => 'INNODB'
> );
> 
> $dbc = MDB2::singleton($mydsn, $config);
> 
> 
> That's it ???

yes

> Will MDB2_Schema create all tables using InnoDB with
that configuration?

yes

> Is it possible to mix 'table drivers' using
MDB2_Schema? I guess no? :-(

mysqldump .. replace s/MyISAM/InnoDB and reimport is the
easiest way

regards,
Lukas

-- 
PEAR Development Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php