Is it possible to change a single database to use InnoDB instead of myISAM on mysql

Question

I want have a single database that uses InnoDB tables instead of myISAM tables (myISAM gives me good performance generally so I don't want to stop using it altogether).

Is it possible to specify that a database use InnoDB tables if the default is myISAM.

Answer 1

If you use phpmyadmin, it's easy to specify what engine to use. I think this is done on a table by table basis. If you want the whole database to be InnoDB, just change that option for each table in the interface.

Answer 2

The short answer is yes:

ALTER TABLE `my_table` Engine=InnoDB charset=utf8 collate=utf8_bin;

Answer 3

You can always specify the engine type you want to use during table creation.

CREATE TABLE customers (a INT, b CHAR (20)) ENGINE=InnoDB;

Answer 4

There is no way to specify a storage engine for a certain database, only for single tables, as others have pointed out. You can, however, specify a storage engine to be used during one session with

SET storage_engine=InnoDB;

so you don't have to specify it for each table.

Answer 5

You can specify the database engine for the tables in the database. You can even have InnoDB and MyISAM engines for different tables within the same database.

I dont think you can specify the engine at the database level.