1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How to enable INNODB Engine in phpMyAdmin

Discussion in 'MySQL' started by jimmy4feb, Jan 10, 2010.

  1. #1
    Hello Everybody,

    I am using PhpMyAdmin version: 3.2.0.1 & I want to enable INNODB engine in this version of PhpMyAdmin.
    SEMrush
    When I am running query:

    SHOW ENGINES;
    Code (markup):
    Then I see following result:


    Engine: InnoDB
    Support: No
    Code (markup):
    Please tell me how I can make Support: Yes.

    Thanks in advance,

    Jimmy
     
    Last edited: Jan 10, 2010
    jimmy4feb, Jan 10, 2010 IP
    SEMrush
  2. koko5

    koko5 Active Member

    Messages:
    394
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Hello , Jimmy4feb ,

    phpmyadmin has no deal with it so you didn't ask the correct question.
    Because you didn't mention your operating system and mysql server version I'm posting these 2 links ( hope it will help ) :
    INNODB
    InnoDB for XAMPP/LAMPP
    If you are using some hosting company and you have no control over the system, you've to ask admin/support to enable InnoDB.
    Regards,
    Nick
     
    koko5, Jan 10, 2010 IP
  3. jimmy4feb

    jimmy4feb Peon

    Messages:
    56
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Hello Koko5,
    Thanks once again for your reply,

    I am using Server version: 5.1.36-community-log & Windows XP S2 operating system.
    I am making an database driven website on my local machine right now & later I will upload it on server for online access.
    Can you please help me now.

    Thanks once again,
    Jimmy
     
    Last edited: Jan 10, 2010
    jimmy4feb, Jan 10, 2010 IP
  4. koko5

    koko5 Active Member

    Messages:
    394
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    70
    #4
    Hi again,Jimmy4feb,

    please download this archive, unzip it and follow the instructions in Readme.txt.
    When everything is done, reboot mysql server and now show engines must be "Yes" for InnoDB.
    Regards,
    Nick
     
    koko5, Jan 10, 2010 IP