Unknown/unsupported storage engine: InnoDB | MySQL Ubuntu
I recently upgraded from the previous LTS Ubuntu to Precise and now mysql refuses to start. It complains of the following when I attempt to start it:
╰$ sudo service mysql restart
stop: Unknown instance:
start: Job failed to start
And this shows in "/var/log/mysql/error.log":
120415 23:01:09 [Note] Plugin 'InnoDB' is disabled.
120415 23:01:09 [Note] Plugin 'FEDERATED' is disabled.
120415 23:01:09 [ERROR] Unknown/unsupported storage engine: InnoDB
120415 23:01:09 [ERROR] Aborting
120415 23:01:09 [Note] /usr/sbin/mysqld: Shutdown complete
I've checked permissions on all the mysql directories to make sure it had ownership and I also renamed the previou ib_logs so that it could remake them. I'm just getting no where with this issue right now, after looking at google results for 2 hours.
After checking the logs I found the following error:
[ERROR] Unknown/unsupported storage engine: InnoDB
I removed these files:
rm /var/lib/mysql/ib_logfile0
rm /var/lib/mysql/ib_logfile1
at /var/lib/mysql
This resolved my problem after restart.
If you really need skip-innodb
(use case: low memory footprint), then of course you don't have to comment it out. However, if InnoDB is the default storage engine, the server will fail to start until you tell it which storage engine to use instead, e.g. default-storage-engine=myisam
for MyISAM.
So, try this:
$ sudo -u mysql mysqld --skip-innodb --default-storage-engine=myisam