Results 1 to 4 of 4

Thread: enable innodb using phpmyadmin

  1. #1
    Join Date
    Oct 2005
    Posts
    449

    enable innodb using phpmyadmin

    anyone knw how to enable innodb (storage engines) using phpmyadmin?
    i tried to use the command which i found in MySQL reference manual :

    Can anyone tell me how to enable innodb by using phpmyadmin ? I have also attempted to use the command that I found in MySQL reference manual which was but that table will auto save it in some other storage engine.

    "Enables the InnoDB storage engine, if the server was compiled with InnoDB support. Use --skip-innodb to disable InnoDB.
    Determined and Forceful
    Emotional and Intuitive
    Powerful and Passionate
    Exciting and Magnetic

  2. #2
    Join Date
    Jan 2006
    Posts
    605

    Re: enable innodb using phpmyadmin

    You can enable MySQL InnoDB Storage Engine Support in XAMPP Installation. Just follow the steps given here and you will be good to go.

  3. #3
    Join Date
    Jan 2006
    Posts
    2,257

    Re: enable innodb using phpmyadmin

    This happens because row count is only an estimate for InnoDB tables due to the storage format. For MyISAM on the other hand, MySQL maintains an exact row count. It seems odd because sometimes with the cardinality being different the number of rows returned in the select are different quite a bit of the time.
    With great power comes great responsibility - Spiderman's Uncle

    The Greatest Sig Ever

  4. #4
    Join Date
    Jan 2006
    Posts
    4,221

    Re: enable innodb using phpmyadmin

    Check the my.ini/my.cnf files at the following locations
    Windowns Install Dir\my.ini
    C:\my.cnf
    Or use Windows search option

    If you are unable to find any such file, then create a new one.

Similar Threads

  1. PHP - Database and PHPMyAdmin
    By Botan in forum Software Development
    Replies: 3
    Last Post: 05-01-2011, 05:28 AM
  2. How do I enable InnoDB storage in phpmyadmin?
    By s10gah in forum Networking & Security
    Replies: 3
    Last Post: 29-10-2010, 03:05 AM
  3. cPanel - innoDB not enabled
    By Parvati in forum Technology & Internet
    Replies: 5
    Last Post: 23-06-2010, 10:35 AM
  4. Recovery of data from InnoDB table
    By Macario in forum Software Development
    Replies: 4
    Last Post: 08-12-2009, 10:10 PM
  5. MySQL MyISAM vs InnoDB
    By tombman in forum Software Development
    Replies: 5
    Last Post: 13-04-2009, 03:42 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,694,340.44693 seconds with 17 queries