Activating InnoDB Support on MySQL-XAMPP

InnoDB support for MySQL Database Engine is not enabled in the my.cnf configuration file on XAMPP by default. If you need InnoDB features, such as one to many or many to many table relationships on foreign key constraints, or transaction-safe commands such as commit, rollback and crash recovery capabilities, you may activating innoDB support with a few step.

To enable the InnoDB storage engine, navigate to “my.cnf” config file location. If you followed my previous posting about XAMPP Installation, my.cnf file can be found on /opt/lampp/etc, and edit the my.cnf.

Search and locate to this line :

# Comment the following if you are using InnoDB tables

so, this line will looks like :

innodb_data_home_dir = /opt/lampp/var/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /opt/lampp/var/mysql

Re-start XAMPP with konsole or terminal,

/opt/lampp/lampp restart

One thought on “Activating InnoDB Support on MySQL-XAMPP

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.