Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    3

    Talking Unanswered: How to make InnoDB the default??

    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

  2. #2
    Join Date
    Apr 2004
    Location
    Europe->Sweden->Stockholm
    Posts
    71
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •