Tohir Solomons

Getting Innodb on Xampp for Windows

Posted on the October 12th, 2005 under Uncategorized by Tohir

I thought switching to Xampp would allow me to be exposed to other languages such as Python and Perl, but alas it seems not to have been so yet.

For the past few weeks I’ve been trying to get innodb tables to work on Xampp, without much luck until today. I went from forum to forum, tried everything and was on the verge of giving up and doing a normal separate installation. Worst of all, it came down to one character!

On this forum for example, it says:

Go to your mysql/bin folder and edit the “my” file and uncomment the innodb lines –

skip-innodb
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = e:/apachefriends/xampp/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = e:/apachefriends/xampp/mysql/
innodb_log_arch_dir = e:/apachefriends/xampp/mysql/

The last step in all of this should be comment skip-innodb, so the final listing will look like this:

#skip-innodb
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = e:/apachefriends/xampp/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = e:/apachefriends/xampp/mysql/
innodb_log_arch_dir = e:/apachefriends/xampp/mysql/

Thank God I managed to get this to work, as well as Python now. The steps for that is much much more clearer.