Mengaktifkan InnoDB Storage MySQL pada XAMPP

1. Edit file my.cnf di folder /instalation_path/xampp/mysql/bin/, instalation_path tempat intalasi xampp

sebelum diedit :

# Comment the following if you are using InnoDB tables

skip-innodb

#innodb_data_home_dir = "D:/xampp/mysql/"

#innodb_data_file_path = ibdata1:10M:autoextend

#innodb_log_group_home_dir = "D:/xampp/mysql/"

#innodb_log_arch_dir = "D:/xampp/mysql/"

## You can set .._buffer_pool_size up to 50 - 80 %

## of RAM but beware of setting memory usage too high

#innodb_buffer_pool_size = 16M

#innodb_additional_mem_pool_size = 2M

## Set .._log_file_size to 25 % of buffer pool size

#innodb_log_file_size = 5M

#innodb_log_buffer_size = 8M

#innodb_flush_log_at_trx_commit = 1

#innodb_lock_wait_timeout = 50

setelah diedit

# Comment the following if you are using InnoDB tables

#skip-innodb

innodb_data_home_dir = "D:/xampp/mysql/"

innodb_data_file_path = ibdata1:10M:autoextend

innodb_log_group_home_dir = "D:/xampp/mysql/"

innodb_log_arch_dir = "D:/xampp/mysql/"

## You can set .._buffer_pool_size up to 50 - 80 %

## of RAM but beware of setting memory usage too high

innodb_buffer_pool_size = 16M

innodb_additional_mem_pool_size = 2M

## Set .._log_file_size to 25 % of buffer pool size

innodb_log_file_size = 5M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 50

2. stop kemudian start lg service mysql lewat control panel XAMPP

jeng jeng akhirnya, bisa menggunakan engine tabel innoDB :)