Page 1 of 1

How Do I activate innodb ?

PostPosted: 19. January 2012 14:06
by mac10
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

Re: How Do I activate innodb ?

PostPosted: 26. January 2012 18:49
by JonB
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)

Re: How Do I activate innodb ?

PostPosted: 29. October 2012 12:16
by WayOfLive
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?

Re: How Do I activate innodb ?

PostPosted: 29. October 2012 18:24
by Altrea
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