Page 1 of 1

Cannot activate InnoDB Engine on XAMPP 1.8.3 for Magento

PostPosted: 09. August 2013 12:57
by for8aby
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
#skip-innodb
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!

Re: Cannot activate InnoDB Engine on XAMPP 1.8.3 for Magento

PostPosted: 30. August 2013 19:22
by logansam
I'm looking for a solution to this also, have you had any luck with it?