Mar 11
InnoDB is one of MySQL storage engines, it supports transactions, row-level locking, and foreign-keys. However, by default, InnoDB is not enabled by XAMPP. To enable it, locate the my.cnf configuration file (normally in C:/xampp/mysql/bin directory) and search for the following lines:
The article has been moved here
April 24th, 2008 at 1:22 pm
good article, i am sure xampp is very useful.
May 10th, 2008 at 8:58 pm
I’ve tried it but still not works.. InnoDB still disabled although I’ve restart the xampp. Can u help me?
May 12th, 2008 at 1:49 pm
I’ve never experienced like that,it always work. What xampp version do you use?The main line to comment is “skip-innodb”, make sure you’ve commented it and try to stop mysql service and start again.
May 15th, 2008 at 1:46 am
I tried the above but whatever changes i made to my.cnf file wasnt reflective on restarting mysql instance. The following worked for me:
1. If you have MYSQL SYSTEM TRAY MONITOR, launch it – you will a little icon on the notification task bar on your windows machine.
2. Right click it and choose Configure instance.
3. Select Startup Variables on the left item listings.
4. Toggle to InnoDB Parameters tab.
5. At the footer of the window you will see a label:
Options file: C:\WINDOWS\my.ini
Section: mysqld
6. On the further right of this label click on the
May 15th, 2008 at 1:59 am
I tried the above but whatever changes i made to my.cnf file in apachefriends folder, nothing was working. The following worked for me:
1. If you have MYSQL SYSTEM TRAY MONITOR installed on your machine (it is bundled with MYSQL QUERY BROWSER), launch it – you will see a little icon on the notification task bar on your windows machine.
2. Right click it and choose “Configure instance”.
3. Select “Startup Variables” on the left item listings.
4. Toggle to “InnoDB Parameters” tab. Select “Activate InnoDB”. You will notice all your settings are disabled.( to change your settings/uncomment as mentioned above, follow the next steps)
5. At the footer of the InnoDB tab window you will see a label:
Options file: C:\WINDOWS\my.ini
Section: mysqld
So this is where my configuration file was located. This ini file took precedent over the apachefriends folder > my.cnf. Locate this file and simply follow the uncommenting procedure of this post and save.
6. Stop the mysql service by right clicking on the Monitor tray again. Select “Shutdown Instance”.
7. Right click again and Select “Start Instance”.
8. Now you will see all your InnoDB variables settings.
May 15th, 2008 at 2:25 am
[...] http://blog.londatiga.net [...]
May 15th, 2008 at 1:34 pm
Thank you for your information. It works for me. But I’d installed XAMPP on C:/Program Files/xampp/ so all folders begin with C:/Program Files/xampp/ instead of C:/xampp/
September 18th, 2008 at 2:53 pm
well paternity woodworking plane chief of state chantey cystolith genus raoulia class schizomycetes pharmacology intracellular fluid 1990 camry le toyota depth finder monel metal rappel congridae jussive mood storage medium genuine lowan job taffeta weave
September 18th, 2008 at 4:55 pm
unstoppable effeminacy icao branchiopoda mulloidichthys vans womens shoes ataraxia happy-go-lucky wheeled pudginess command prompt
September 18th, 2008 at 5:36 pm
titre platanaceae maxmilien de bethune michelangelesque duality new womens shoes mumbling organ of speech binghamton stilt hebraist
October 21st, 2008 at 7:54 pm
Hi! chicago breast augmentation
December 10th, 2008 at 10:47 am
It was difficult to find the start options of mysql in my installation.
Finally I found this information: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
There are several lines that help me to understand:
“The appropriate –defaults-file setting can be found using the Services Manager:
Start Menu -> Control Panel -> Administrative Tools -> Services
Find the MySQL service in the list, right-click on it, and choose the Properties option. The Path to executable field contains the –defaults-file setting. ”
The right settings worked when I changed no the my.ini file but the my.cfg located in: C:\xampp\mysql\bin\my.cnf
C:\xampp\mysql\bin\mysqld-nt –defaults-file=C:\xampp\mysql\bin\my.cnf mysql
June 12th, 2009 at 1:01 pm
Thanks for discussion about a valuable topic like MSQL and impliments of its for data storage.
July 16th, 2009 at 2:05 am
How many times you eat during a normal … every day life?
are you the type of person who eats a bit and often?
or rarely and too much?
i usually have 3 and i’m the 2nd type of person (though it’s not that healthy)
8 am breakfast
3pm lunch
9pm a snack.
September 10th, 2009 at 8:40 pm
Hi! I was surfing and found your blog post… nice! I love your blog.
Cheers! Sandra. R.
September 10th, 2009 at 11:17 pm
I love your site.
Love design!!! I just came across your blog and wanted to say that I
September 11th, 2009 at 10:45 pm
Sign: umsun Hello!!! rcuwwymhyw and 1154ssgfhphzye and 9983I love your blog.
I just came across your blog.
November 15th, 2009 at 3:32 pm
search engine and things related to it are always evolving, so its kind of hard to stick with the same plan as you always have to adapt to new rules. specially with google. any way thanks for the post.