enablng innodb

[witham]

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

[Xplorer]

...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

[KevinASUDevil]

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

[Kodiak3000]

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

[Wiedmann]

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.

[geraldgrogan]

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