Problems with the Windows version of XAMPP, questions, comments, and anything related.
Hi everybody, the current installation of xampp for windows do support InnoDB Tables?
- Posts: 1
- Joined: 07. February 2004 13:53
I had the same problem. Here is what you need to do.
browse to your my.cnf file which by default is in
For me the extension was hidden and I could not right click and 'open with' so you need to open it with a text editor. I used wordpad.
After opening the file you need to comment out the line:
skip-innodb e.g. # skip-innodb
then uncomment the lines below that. For me the section from the skip-innodb looks as follows:
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = c:/apachefriends/xampp/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = c:/apachefriends/xampp/mysql/
innodb_log_arch_dir = c:/apachefriends/xampp/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
set-variable = innodb_lock_wait_timeout=50
Hope that makes sense.
- Posts: 3
- Joined: 30. June 2004 08:13
Return to XAMPP for Windows
Who is online
Users browsing this forum: No registered users and 46 guests