how to create innodb database in mysql

Discussion in 'MySQL' started by look4guna, Jan 9, 2011.

0
  1. #1
    Hi friends,
    i want to create database type as innodb. searched in web but only ended up with creating tables as innodb. if i set to db as innodb type then all tables will be created that type , no need to create each table as this type.

    so can any one tell me what is the command to create database as innodb type, i used following but got error

    CREATE DATABASE "mydd" ENGINE = InnoDB
     
    look4guna, Jan 9, 2011 IP
  2. jkl6

    jkl6 Peon

    Messages:
    70
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Take a look at this link
     
    jkl6, Jan 10, 2011 IP
  3. look4guna

    look4guna Active Member

    Messages:
    60
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #3
    thanks jkl6. But am creating a tool that used to create db with predefined tables, so i dont hav the knowledge of users default storage engine. thats why i tried to set this database as
    Innodb. how to make it?
     
    look4guna, Jan 10, 2011 IP