wiki:MySql
Warning: Can't synchronize with repository "(default)" (Unsupported version control system "svn": No module named svn). Look in the Trac log for more information.

Version 2 (modified by anonymous, 13 years ago) (diff)

--

MySQL Setup

MySQL and Transactions

TurboGears requires transations. MySql's default database engine does support transactions. TurboGears requires innodb tables.

when the command:

tg-admin sql create

is issued, the default table type is used.

Mike summerized the options in an excellent email.

Mike Stephen Dec 17, 5:17 pm show options From: "Mike Stephen" <mike.r.step...@…> - Find messages by this author Date: Sat, 17 Dec 2005 14:17:21 -0800 Local: Sat, Dec 17 2005 5:17 pm Subject: Re: TurboGears, MySQL, Transactions, and InnoDB tables Oh My

Hi Mike,

I'm using MySQL with turbogears and they're working very nicely together for me. What you need to do is to configure MySQL so that it uses InnoDB as the default storage engine as Jonathan pointed out, so that when you issue a create table statement, it'll be an InnoDB table by default.

Do you have the MySQL Administrator GUI installed? If so, select StartUp? Variables from the left pane, then choose the General Parameters tab. Down the bottom you'll see a Default Storage section. Choose InnoDB from the drop-down.

Alternatively, you could add the following line to the [mysqld] section of your my.ini file:

default-storage-engine=INNODB

Regards,

Mike.