Help, my.cnf file is missing and I need to activate Innodb!

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

Help, my.cnf file is missing and I need to activate Innodb!

Postby yenyen » 13. August 2007 16:18

I am trying to find my mysql/bin/my.cnf file on my xampp install, but I can't seem to find it anywhere.

Please advise how can I activat innodb support without it! (MySql is being run as a service)

Thanks!
yenyen
 
Posts: 2
Joined: 13. August 2007 16:13

Postby Wiedmann » 13. August 2007 19:09

am trying to find my mysql/bin/my.cnf file on my xampp install, but I can't seem to find it anywhere.

http://www.apachefriends.org/en/xampp-windows.html#1172
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Help, my.cnf file is missing and I need to activate Inno

Postby Izzy » 14. August 2007 01:59

yenyen wrote:I am trying to find my mysql/bin/my.cnf file on my xampp install, but I can't seem to find it anywhere.

Please advise how can I activat innodb support without it! (MySql is being run as a service)

Thanks!

Here is a quote from the xampp\readme_en.txt file
* MYSQL NOTES:

(2) To use the MySQL Daemon with "innodb" for better performance, please edit the "my" (or "my.cnf") file in the C:\xampp\mysql\bin directory or for services the c:\my.cnf for windows NT/2000/XP. In there, activate the "innodb_data_file_path=ibdata1:30M" statement. Attention, "innodb" is not recommended for 95/98/ME.
To use MySQL as Service for NT / 2000 / XP, simply copy the "my" / "my.cnf" file to "C:\my", or "C:\my.cnf". Please note that this file has to be placed in C:\ (root), other locations are not permitted. Then execute the "mysql_installservice.bat" in the mysql folder.

(If that note (2) is not correct then it needs to be changed by the XAMPP authors and included in the next release).

To edit the "my" mysql/bin/my file which looks like a link, drag it into your favorite text editor.
When finished editing select Save from the editor's menu.
HTH

=================================================
Take a look at the new DeskTopXampp launch control posted by ridgewood:
http://community.apachefriends.org/f/viewtopi ... 967#103967

The DeskTopXampp launch control for XAMPP and XAMPPlite (DTX.exe)
is available here:
http://zedfiles.com/DTX/

I highly recommend DTX.
=================================================
Last edited by Izzy on 02. September 2007 04:35, edited 1 time in total.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

THANKS!

Postby yenyen » 14. August 2007 15:41

To edit the "my" mysql/bin/my file which looks like a link, drag it into your favorite text editor.
When finished editing select Save from the editor's menu.


Thanks a lot! I never would have even thought of that. javascript:emoticon(':oops:')
yenyen
 
Posts: 2
Joined: 13. August 2007 16:13


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 180 guests