How to change DATABASE ENGINE to innodb?

Stephan_Craft · 02-20-2010, 01:41 AM

Hi,
How to change DATABASE ENGINE to innodb? by default it's Myisam
I tried
ALTER DATABASE database_name ENGINE ='innodb';
ERROR 1064 (42000): You have an error in your SQL syntax;

jlinkels · 02-20-2010, 08:27 AM

The storage engine is specified per table. If you want to change it, you'd have to alter the table:

Code:

ALTER TABLE t ENGINE = INNODB;

You can also set the default storage type to INNODB, of you can create a table using INNODB.
http://dev.mysql.com/doc/refman/5.0/...e-engines.html

jlinkels

Stephan_Craft · 02-20-2010, 11:29 PM

That's I know. my question was how to change DATABASE engine

jlinkels · 02-21-2010, 07:18 AM

If it is specified per table, how can you change it per database? You can set a default value for the database so all new tables will be created using that default value.

jlinkels

chrism01 · 02-21-2010, 09:48 PM

Set the default storage engine:

http://dev.mysql.com/doc/refman/5.0/...r-options.html

Quote:

--default-storage-engine=type
Command-Line Format --default-storage-engine=name
Config-File Format default-storage-engine

Set the default storage engine (table type) for tables. See Chapter 13, Storage Engines.

http://dev.mysql.com/doc/refman/5.0/...e-engines.html

Quote:

If you omit the ENGINE or TYPE option, the default storage engine is used. Normally, this is MyISAM, but you can change it by using the --default-storage-engine or --default-table-type server startup option, or by setting the default-storage-engine or default-table-type option in the my.cnf configuration file.