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,