Q:

How to disable innodb in mysql?

I added the line 'skip_innodb' in my.cnf file to disable innodb and restarted the mysqld. But,It is not effecting in database. Is there any alternative solutions ?

A:

If you are using MySql 5.5 or above,
ignore-builtin-innodb

and
default-storage-engine = myisam

under
[mysqld]

in  /etc/my.cnf

A:

Add skip-innodb under [mysqld] in my.cnf and then restart the MySQL server 
See mysql log file for the success using tail -100 log_file_name_with_full_path
Verify using following query:
SHOW ENGINES;

A:

Try
innodb=OFF
default-storage-engine=MyISAM

MyISAM is just a example you can choose wathever you want there
You can read more here http://www.webhostingtalk.com/showthread.php?t=1052143

