+44(0) 1234 567 890 info@domainname.com

October 21, 2010

Enabling InnoDB Engine in MySQL

10:45 AM

Share it Please
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 komentar:

Wildan said...

terima kasih, artikel yang sangat bermanfaat