mysql: unknown option '--skip-innodb'

Question

In trying to disable innodb by adding this to mysql config

 [mysql]
 skip-innodb

But I get the error shown in title.. I also tried to change [mysql] to [mysqld] with no luck.

SHOW ENGINES: http://pastebin.com/raw.php?i=iq7NqQhM

MySQL version: 5.5.34-0ubuntu0.13.10.1 (Ubuntu)

If the `--skip-innodb` option isn't recognised, it suggests that the InnoDB plugin isn't loaded. Can you start MySQL without the above option and run the query `SHOW ENGINES;`? — plasmid87, Nov 24 '13 at 19:29
I added show engines command and mysql version in the question — MultiformeIngegno, Nov 24 '13 at 23:13

nandoP · Answer 1 · 2013-11-24T20:06:31.367

0

unless you are running an old version, you need to load the innodb engine, as the "mysql" database now uses it for its tables internal tables (ie. "mysql"), and so wont start without it

older versions you can exclude loading the innodb engine, per your example, so as to make it not load on restart

that said, innodb is better that myiasm for most use cases

EDIT:

you have to post more like meaningful my.cnf; show engines; show variables like "%...%", show status like "%...%"....

edited Nov 24 '13 at 20:06

answered Nov 24 '13 at 19:30

nandoP

2,021
14
15

I added show engines command and mysql version in the question – MultiformeIngegno Nov 24 '13 at 23:14

mysql: unknown option '--skip-innodb'

1 Answers1