Configure Default MySQL Engine to Use MyISAM

Issue: New database tables are being created as InnoDB (when using MariaDB / MySQL). They should be MyISAM.

Solution: The default engine is likely configured as InnoDB.

SSH into server as root, and check database configuration:

nano /etc/my.cnf

You may see something similar to:

[mysqld]
bind-address=127.0.0.1
default-storage-engine=InnoDB
innodb_file_per_table=1
max_allowed_packet=268435456
open_files_limit=10000
local-infile=0
init_connect='SET collation_connection=utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
query_cache_type = 1
query_cache_limit = 1M
query_cache_size = 128M

Changed the line: default-storage-engine=InnoDB to:

default-storage-engine = MyISAM

If using cPanel, restart the DB with:

/usr/local/cpanel/scripts/restartsrv_mysql

If not using cPanel, restart the database with:

/etc/init.d/mysql restart

Leave a comment

BlogLogistics