HostOnNet Blog

ERROR 1286 (42000): Unknown storage engine ‘InnoDB’

Looking for Linux Server Admin or WordPress Expert? We can help.

After upgrading MySQL to MariaDB 10.0.23, i got following error

01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
root@server48 [/usr/local]# mysql jscsocce_jsc
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 11515
Server version: 10.0.23-MariaDB MariaDB Server
 
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
MariaDB [jscsocce_jsc]> select * from school;
ERROR 1286 (42000): Unknown storage engine 'InnoDB'
MariaDB [jscsocce_jsc]>

This was because InnoDB was not enabled in /etc/my.cnf

To enable InooDB, edit

1
vi /etc/my.cnf

add

1
2
3
4
5
innodb_buffer_pool_size=16M
innodb_additional_mem_pool_size=500K
innodb_log_buffer_size=500K
innodb_thread_concurrency=2
innodb_file_per_table=1

Now restart MariaDB, on CentOS 7 server, run

1
2
systemctl stop mariadb
systemctl start mariadb

Posted in MySQL

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.