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
1PLs Company - #1Payday.Loans Agency - Loans online and near me $100-$2500 (Same Day)
Powered by MySQL
 

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 FAQs: Recently Added FAQs

About MySQL FAQs: Site Map | Bookmark Us | Recommend this Site to Your Friend | Contact Us

Useful Links: Wikipedia.org | Oracle.com | w3schools.com | www.php.net | Github.com

© 2023  www.mysqlfaqs.net
All rights reserved.