How do I set the default table type as innodb in my.cnf?
For mysql...is there a way to set it so that every table that gets created is innodb?
Edit your my.cnf file to set following in the [mysqld] section (or the section your MySQLd reads):
default-storage-engine=InnoDB
After restarting the MySQL server, InnoDB should be the new default. To verify this, run the SQL statement:
SHOW ENGINES;
...The InnoDB line should be indicated as DEFAULT.
Note that the default-storage-engine option is just an alternate name for default-table-type.
Yes, you can
default-storage-engine=InnoDB
default-table-type=InnoDB