how to enable InnoDB in MySQL

Und alles was mit phpMyAdmin seine Verwandtschaft findet hat hier seinen Platz.

how to enable InnoDB in MySQL

Postby shrg18 » 16. September 2007 02:26

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.
shrg18
 
Posts: 43
Joined: 16. August 2007 13:59
Location: windsor, on, canada
XAMPP Version: 5.6.3
Operating System: windows 8

Postby sari42 » 16. September 2007 08:25

but could not open it
??
use a plain text editor (in case you are using windows: it appears just as "my")
sari42
 
Posts: 800
Joined: 27. November 2005 18:28

Postby shrg18 » 16. September 2007 14:06

sari42 wrote:
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.
shrg18
 
Posts: 43
Joined: 16. August 2007 13:59
Location: windsor, on, canada
XAMPP Version: 5.6.3
Operating System: windows 8

Postby lindabehr » 29. October 2007 08:10

i've download xampp 1.6.4 ..but i cant find the my.cnf ...where's its been placced?
lindabehr
 
Posts: 1
Joined: 29. October 2007 08:07
Location: kuala lumpur,malaysia

Postby Wiedmann » 29. October 2007 08:29

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
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

new version

Postby shrg18 » 13. December 2007 03:18

1. open my.cnf

2.# comment out skip_innodb
#skip_innodb

restart the window
shrg18
 
Posts: 43
Joined: 16. August 2007 13:59
Location: windsor, on, canada
XAMPP Version: 5.6.3
Operating System: windows 8


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 4 guests