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 uninstall Innodb Engine?

My all applications do not use InnoDB table type. With me phpMyAdmin shows InnoDB Storage Engine.  I assume that InnoDB is installed with MySQL Server installation.  Whereas I am not in need of this engine so I want to uninstall InnoDB Engine.  Can you help me to explain, how to uninstall InnoDB Engine or InnoDB table type in MySQL?

Answer No: 163

To get InnoDB un-installed, open my.ini file and do the following:

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

Then refresh phpMyAdmin, InnoDB Engine will be no more 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-install-Innodb-Engine How to install 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.