Disable innodb engine in MySQL

This entry is part 5 of 9 in the series: Administering MySQL from the command line

To disable a storage engine in mysql we must:

Edit the my.cnf file
# vim /etc/my.cnf
Add to the file
For example, to disable innodb add to the file
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:

MySQL engines

Leave a Comment

Your email address will not be published. Required fields are marked *