3 messages in com.mysql.lists.mysqlRe: InnoDB engine as default for an e...
FromSent OnAttachments
symbulos partners28 Jan 2005 05:02 
Gleb Paharenko28 Jan 2005 05:52 
Artem Koltsov28 Jan 2005 05:52 
Subject:Re: InnoDB engine as default for an entire database
From:Gleb Paharenko (gleb@ensita.net)
Date:01/28/2005 05:52:01 AM
List:com.mysql.lists.mysql

Hello.

You can change it by using the --default-storage-engine or --default-table-type server startup option, or by setting the storage_engine or table_type system
variable. See: http://dev.mysql.com/doc/mysql/en/storage-engines.html

symbulos partners <part@symbulos.com> wrote:

Dear friend,

is it possible to select the InnoDB engine as default for an entire database?

What we want is to create all InnoDB tables, without using the declaration type=innodb.