The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to create InnoDB in cPanel

Discussion in 'General Discussion' started by maxihost2, Sep 14, 2005.

  1. maxihost2

    maxihost2 Well-Known Member
    PartnerNOC

    Joined:
    Feb 28, 2005
    Messages:
    55
    Likes Received:
    0
    Trophy Points:
    6
    The table type is MyISAM as default, one of my users is wanting to create a InnoDB type table, how this can be done ?
     
  2. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    phpMyAdmin lets you choose the table type when creating a table and once a table exists you can convert between table types.
     
  3. Secret Agent

    Secret Agent Guest

    I can duplicate this. I cannot find the option in phpmyadmin and I'm using the latest version of cpanel/mysql

    Where can InnoDB be enabled?
     
  4. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    /etc/my.cnf
     
  5. Secret Agent

    Secret Agent Guest

    That means what exactly? Am we supposed to guess what goes in there? Please be specific at least.
     
  6. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    When you create a new database table in phpmyadmin, you first enter the table name and the number of fields and then proceed to another page where you choose the names and properties of the fields.

    It is on the same page that you choose the table type. Below the field properties, just to the right of the table comments box is a drop-down menu labelled "Table type", from which you can choose:

    MyISAM
    MERGE
    HEAP
    MEMORY
    InnoDB
    ISAM

    You can also migrate between table types after a table has been created. When viewing a specific table, select the 'Operations' table and you will see again a select-menu labelled "Table type" which again give you the same choices as above.

    These options are present for me in phpmyadmin 2.6.4-pl2 and have been present within phpmyadmin for as long as I can remember, which would be coming up to five years.
     
  7. Secret Agent

    Secret Agent Guest

    I only see these:

    MyISAM
    MERGE
    HEAP
    MEMORY
    ISAM

    What is the proper way to install/enable Innodb?
     
  8. haze

    haze Well-Known Member

    Joined:
    Dec 21, 2001
    Messages:
    1,550
    Likes Received:
    3
    Trophy Points:
    38
Loading...

Share This Page