October 21, 2010

Enabling InnoDB Engine in MySQL

I just try (again) the new CMS (Content Management System) which built by CodeIgniter PHP framework. When I installed by running $(host)/installer, on the fourth step I got messages that the installing cann't be continue. This is the messages that I got, "The installer could not add any tables to the Database. The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working".

It's occured because in my computer which I used, the InnoDB engine is disabled by default. We can enabling it by edit file my.ini in Mysql folder installed.


The following is the step how to enabling MySQL InnoDB.

1. Shut down your MySQL server (stop the service)
2. Open my.ini (mysql's config file), which is located in your MySQL program folder.
3. In my.ini, find:
skip-innodb
    
4. Replace this line with:
# skip-innodb
 
5. Save the file.
6. Start the MySQL server again.

After that I continue my installation and alhamdulillah, it running well. Now we can try the features of this CMS :-) .

1 comment:

Silahkan berkomentar sesuai dengan penilaian anda terhadap apa yang saya posting