Advertisement: Over 100,000 Jobs Worldwide. Click here to find one for you.

MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors


http://www.careermidway.com
 

How to install Innodb Engine?

I am new to MySQL and want to have InnoDB table type for my database tables.   With me phpMyAdmin does not show me InnoDB Storage Engine.  I assume that InnoDB was not installed with MySQL Server installation.  How to install InnoDB Engine or InnoDB table type in MySQL.

Answer No: 47

To get InnoDB enabled, open my.ini file and do the following:

1. Find skip-innodb directive from this file and place # before it to comment out. It will appear like #skip-innodb.
2. Save my.ini and restart the MySQL.

Then refresh phpMyAdmin, InnoDB Engine will be available to use.

Related MySQL FAQs to the Above FAQ

When-should-we-use-innodb-engine When should we use innodb engine?

How-to-create-innodb-table-in-MySQL How to create innodb table in MySQL?

How-to-uninstall-Innodb-Engine How to uninstall Innodb Engine?

How-to-rename-a-database-with-full-Innodb-Tables How to rename a database with full Innodb Tables?

How-to-take-data-back-up-for-InnoDB-tables-like-copy-paste How to take data back up for InnoDB tables like copy paste?
About SiteAbout FAQsAffiliates and Sponsors
© 2007 - 2010  www.mysqlfaqs.net
All rights reserved. The site is owned and operated by Mr. Javed Bhatti - Pakistan.