how to enable InnoDB in MySQL

[shrg18]

I am using XAMPP in windows XP, when creating tables in the phpMyAdmin, the InnoDB type is not in the selection list.

I found the my.cnf file in C:\xampp\mysql\bin, but could not open it to enable InnoDB support.

Anyone can tell me what to do and how to do it?

Thanks.

[sari42]

but could not open it

??
use a plain text editor (in case you are using windows: it appears just as "my")

[shrg18]

but could not open it

??
use a plain text editor (in case you are using windows: it appears just as "my")

the InnoDB is enabled. thank you.

I used NotePad to upload my.cnf and uncommented the lines regarding InnoDB.

#skip-innodb
innodb_data_home_dir = /opt/lampp/var/mysql/
innodb_dat_file_path = idbdata1:10M:autoextend
innodb_log_group_home_dir = /opt/lampp/var/mysql/
innodb_log_arch_dir = /opt/lampp/var/mysql/

restart windows

InnoDB is among the table type selection list.

[lindabehr]

i've download xampp 1.6.4 ..but i cant find the my.cnf ...where's its been placced?

[Wiedmann]

but i cant find the my.cnf ...where's its been placced?

http://www.apachefriends.org/en/xampp-windows.html#1172
--> \xampp\mysql\bin\my.cnf

[shrg18]

1. open my.cnf

2.# comment out skip_innodb
#skip_innodb

restart the window