Apache Friends Support Forum

can anyone please tell me how to enable innodb as it is currently not avaiable in phpadmin

...seems not to be enabled in the mysql version shipped together with XAMPP 1.5.4a. As I also wanted to have Innodb engine, I tried to figure out how to make the trick and here's what I've come up with.

- install XAMPP from the ZIP-file, in my case into C:\ (so I get the installation under c:\xampp)
- install a downloaded mysql 5.0 into c:\xampp\mysql
- do the rest of the setup manually, by running setup_xampp.bat and all the other bat-files to get the services etc (also achievable by xampp-control.exe)

I am not sure if this is the kosher way of doing things, as I run mysql 5.0.27 against databases coming from mysql 5.0.24, but it has worked for me. Any comments from anybody?

/Z

In english, the best way is to edit the "my" file under \xampp\mysql\bin directory.

Look for the line (63 for me):

Code: Select all

skip-innodb

and comment that out.

Then uncomment the non-comments below it, so it looks like:

Code: Select all

#skip-innodb
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /xampp/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /xampp/mysql/data/
innodb_log_arch_dir = /xampp/mysql/data/
# 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


Super easy (and in English).. Or read the readme_en.txt (line 139 in the 1.5.5 package)

- Kevin

I've run into this time and time again in my search today - this is the solution given in every post in every forum I've read, but in every case, the next post is "but I can't find that file in my directory"...

Neither can I.

Could it be somewhere else? Could the file path be different in this version of XAMPP?

Cheers

Could it be somewhere else? Could the file path be different in this version of XAMPP?

No, and no.

It's really so simple:
- select the file "my" (aka "my.cnf") in explorer, path "\xampp\mysql\bin", with your mouse
- drag 'n drop the file in your editor

Or like that:
Windows Taskbar --> Start --> Run:
notepad \xampp\mysql\bin\my.cnf

Or use the file open dialogue in your preferred text editor.

You will need to also update the file called my.ini located in C:\WINDOWS