Using InnoDB with XAMPP MySQL

From HostThyself

Jump to: navigation, search

XAMPP default installation of MySQL comes with InnoDB disabled.

To enable InnoDB, simply follow these steps. (These instructions are verified on Windows version of XAMPP)

  1. Go to the mysql/bin folder under the folder where XAMPP is installed.
  2. edit the file my and uncomment the innodb related lines
  3. Comment skip-innodb 
#skip-innodb
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = c:/apachefriends/xampp/mysql/
innodb_data_file_path = ibdata1:10M:autoextend 
innodb_log_group_home_dir = c:/apachefriends/xampp/mysql/
innodb_log_arch_dir = c:/apachefriends/xampp/mysql/
Retrieved from "http://www.hostthyself.com/Using_InnoDB_with_XAMPP_MySQL"
Personal tools