Search code examples
mysqldatabaseinnodbmyisamdatabase-schema

Mysql InnoDB database

All of my tables are InnoDB but PHPMyAdmin shows that the database is MyIsam: http://img708.imageshack.us/i/201103080940551280x800s.png/ How do I create new MySQL databases using InnoDB? Running MySQL 5.1, in a Debian Sid box. Thank you.

Solution

  • AFAIK it is showing MyISAM because that is your default storage engine on that database, i.e. if you were to create a new table and not specify the engine then it would be MyISAM.

    You can change the default storage engine in your my.cnf file:

    default-storage-engine=INNODB