Apache Friends Support Forum

Is InnoDB supported? I know MySQL has the support, it is not clear if it is enabled in XAMPP and if so how to 'enable it'.

Thanks for the great product and site!

Edit the following:

/opt/lampp/etc/my.cnf

Search for InnoDB:

Comment out (#) the line:
skip-innodb

Uncomment:
innodb_data_home_dir = /opt/lampp/var/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /opt/lampp/var/mysql
innodb_log_arch_dir = /opt/lampp/var/mysql
set-variable = innodb_lock_wait_timeout=50

Save the changes. Stop and restart MySQL or stop and restart lampp to be safe

Hope this helps anyone who had the same question as I did