Disable innodb engine in MySQL

To disable a storage engine in mysql we must:

Edit the my.cnf file

# vim /etc/my.cnf

Add to the file

skip-name-the-engine

For example, to disable innodb add to the file

Skip-innodb

Restart the mysql server

CentOS / Fedora / RHEL

# service mysqld restart

Debian, Ubuntu and other distros

# /etc/init.d/mysqld restart

Information about the engines

# mysql - u root - p - e 'show engines;'

The above command would be: