Cannot activate InnoDB Engine on XAMPP 1.8.3 for Magento

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Cannot activate InnoDB Engine on XAMPP 1.8.3 for Magento

Postby for8aby » 09. August 2013 12:57

What I need to do is to activate the INNODB engine in order to use Magento on localhost.

I cannot activate the InnoDB engine on my sql on XAMPP 1.8.3. The truth is that the XAMPP is ment for win32 and I have WIndows 7 on 64 bits.
I have edited the "my" configuration file in xampp/mysql/bin as follows:

# Comment the following if you are using InnoDB tables
innodb_data_home_dir = "F:/xampp/mysql/data"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "F:/xampp/mysql/data"
innodb_log_arch_dir = "F:/xampp/mysql/data"
## Youe can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

What happens is that MySQL does not start. However, if I comment this line:
innodb_log_arch_dir = "F:/xampp/mysql/data"

MySQL will start but I will get an error when trying to configure Magento saying that the database server does not support the InnoDB engine.

If I leave that line uncommented (like all forum posts say that need to be in order for the InnoDB engine so start), the MySQL won't start with the following error:

2013-08-09 14:11:33 216 [ERROR] f:\xampp\mysql\bin\mysqld.exe: unknown variable 'innodb_log_arch_dir=F:/xampp/mysql/data'
2013-08-09 14:11:33 216 [ERROR] Aborting

Thank you very much for you help!
Danke für eure Hilfe!
Posts: 2
Joined: 09. August 2013 12:45
Operating System: windows 7

Re: Cannot activate InnoDB Engine on XAMPP 1.8.3 for Magento

Postby logansam » 30. August 2013 19:22

I'm looking for a solution to this also, have you had any luck with it?
Posts: 1
Joined: 30. August 2013 19:12
Operating System: Windows 7

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 33 guests