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

When should we use innodb engine?

How to create innodb table in MySQL?

How to uninstall Innodb Engine?

How to rename a database with full Innodb Tables?

How to take data back up for InnoDB tables like copy paste?

Send This Page to Friend