InnoDB tables?

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

InnoDB tables?

Postby Passh Reloaded » 07. February 2004 13:59

Hi everybody, the current installation of xampp for windows do support InnoDB Tables?

Thanxz :lol:
Passh Reloaded
 
Posts: 1
Joined: 07. February 2004 13:53

Need to edit my.cnf

Postby ajgraaff » 04. January 2005 14:11

I had the same problem. Here is what you need to do.

browse to your my.cnf file which by default is in

- C:\apachefriends\xampp\mysql\bin

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:

#skip-innodb
# 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
innodb_flush_log_at_trx_commit=1
set-variable = innodb_lock_wait_timeout=50

Hope that makes sense.
Andrew
ajgraaff
 
Posts: 3
Joined: 30. June 2004 08:13


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 124 guests