How to make InnoDB the default??

deanhiller · #1 (**permalink**) 10-25-04, 22:23

I need to make InnoDB the default so type=InnoDB or Engine=InnoDB is not needed on every table create. How can this be done?
thanks,
dean

snorp · #2 (**permalink**) 10-26-04, 00:07

Set the variable table_type to InnoDB. You can use --default-table-type=InnoDB on the command line to the MySQL server or you can set it from the client:

Code:

SET GLOBAL table_type=InnoDB;

I guess you can also add the line

Code:

table_type=InnoDB

to the configuration file in the [mysqld] section

Internet Services

Web Development

Digital Marketing

Consumer Tech