Enabling InnoDB in XAMPP
InnoDB is not enabled in XAMPP's MySQL installation by default. This walkthrough shows you how to enable InnoDB on your copy of XAMPP.
- Find and open your my.cnf file (MySQL configuration file). The location depends on your operating system; take a look at the section below to find out. Note that the extension may be hidden in Windows, so the file may be called "my".
- If there is a skip-innodb line, precede it with a "#" (hash) character to comment it out.
- Uncomment (i.e., remove the "#" character from) all lines beginning with innodb_.
- Save your my.cnf file.
- Restart MySQL using the XAMPP Control Panel.
|Mac OS X||/Applications/xampp/etc/my.cnf|