How Do I activate innodb ?

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

How Do I activate innodb ?

Postby mac10 » 19. January 2012 14:06

Hi...
Q: How do I activate innodb ?
and...
Q: How do I know when innodb has been activate ?
Q: What does 'skip-innodb' heading mean & does it need the # for innodb to function ?

I've tried to activate innodb, without any luck.

Ive followed: http://community.apachefriends.org/f/viewtopic.php?t=26478

Ive edited the 'my' file, at: C:\xampp\mysql\bin
(theres also a file: my_example)
(both file-types are shown as: SpeedDial)

The setup info Ive seen in these files, and in file: readme_en.txt / and on the web, is contradictory... and has not seemed to activate innodb.

So can you please clarify the procedure

originally the line: skip-innodb
...was without the # so I tried adding the # ie: # skip-innodb
...I tried removing the # from: innodb_data_file_path = ibdata1:10M:autoextend
...I tried removing the # from all of the code lines listed under: skip-innodb

Thanks
mac10
 
Posts: 6
Joined: 13. October 2007 16:43
XAMPP Version: 5.5.19
Operating System: Windows 7 64b

Re: How Do I activate innodb ?

Postby JonB » 26. January 2012 18:49

I think the simplest method would probably be to upgrade your XAMPP to either 1.7.4 or 1.7.7. Both come with MySQL 5.5 in which InnoDB is the default engine instead of MyISAM. -- end of problem -- 1.7.4 is a VC6 Apache/PHP compile, 1.7.7 is a VC9 Apache?PHP compile.

Besides InnoDB, you would get many other benefits in the process, including updated PHP and Apache.

Just 'my opinion'.

Otherwise Look Here:
http://dev.mysql.com/doc/refman/5.0/en/ ... ngine.html

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: How Do I activate innodb ?

Postby WayOfLive » 29. October 2012 12:16

ok, fine, but for Mac OS X the latest version is 1.7.3, right? so how can I activated InnoDB engine in this version?
WayOfLive
 
Posts: 1
Joined: 29. October 2012 11:49
XAMPP Version: 1.8.3-1
Operating System: Mac OS X 10.6.8

Re: How Do I activate innodb ?

Postby Altrea » 29. October 2012 18:24

Hi WayOfLive,

WayOfLive wrote:ok, fine, but for Mac OS X the latest version is 1.7.3, right? so how can I activated InnoDB engine in this version?

Wrong forum for that question.
Please ask that question again in the XAMPP for Mac OSX Forum, so that others who are searching for a solution have the chance to find that thread later again.
Thank you

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6534
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 40 guests