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
skip-innodb

so, this line will looks like :

#skip-innodb
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