My Thoughts & Views

Enabling InnoDB Support in Mysql installed with XAMPP

Posted on: June 2, 2007

Recently i installed XAMPP in my system to work on a project. I was creating a table with a foreign key in it,then i came to know that InnoDB Engine is not enabled and i tried to find how to enable it but i didn’t get a clear info at one place so i thought i can share it with the rest of the world.

Here are the steps to enable it.

1. go to xampp directory installed in program files and then open mysql\bin folder.

2. Open the file with the name my(my.cnf) in notepad, actually its config file which has an icon of a computer with a globe at the back side.

3. Comment the line

skip-innodb

4. Uncomment the following lines

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:/Program Files/xampp/mysql/data/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:/Program Files/xampp/mysql/data/
#innodb_log_arch_dir = C:/Program Files/xampp/mysql/data/
# You can set .._buffer_pool_size up to 50 – 80 %
# of RAM but beware of setting memory usage too high
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#set-variable = innodb_lock_wait_timeout=50

5. Save the file and restart the mysql server.

Now you are ready to use InnoDB on your mysql server.

Advertisements

1 Response to "Enabling InnoDB Support in Mysql installed with XAMPP"

Thanks man! After a lot of searching I came across your blog and found this straightforward solution! Thanx!

~greetz

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: