I was migrating server and rsync all databases to new mariadb server. When tried to start mariadb on new server, I was getting this error:
Apr 24 18:30:26 my.server.com mysqld[9703]: 2018-04-24 18:30:26 140298644924544 [ERROR] Plugin 'InnoDB' init function returned error. Apr 24 18:30:26 my.server.com mysqld[9703]: 2018-04-24 18:30:26 140298644924544 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. Apr 24 18:30:26 my.server.com mysqld[9703]: 2018-04-24 18:30:26 140298644924544 [Note] Plugin 'FEEDBACK' is disabled. Apr 24 18:30:26 my.server.com mysqld[9703]: 2018-04-24 18:30:26 140298644924544 [ERROR] Unknown/unsupported storage engine: InnoDB Apr 24 18:30:26 my.server.com mysqld[9703]: 2018-04-24 18:30:26 140298644924544 [ERROR] Aborting
Solution is to generate new ib_logfile0 and ib_logfile1 files. Just try steps bellow.
[root@lol ~]# cd /var/lib/mysql [root@lol mysql]# mv ib_logfile0 ib_logfile0-backup [root@lol mysql]# mv ib_logfile1 ib_logfile1-backup [root@lol mysql]# systemctl start mysql [root@lol mysql]# mysql Welcome to the MariaDB monitor.
It should work.
[kofi]
work for me
# mv /var/lib/mysql/* /opt/
Great!
I was searching for why my mariadb server is not working for almost 24 hours and this did the trick. I’ve upgraded mariadb from 10.4.10 to 10.4.10_1 via homebrew and this happened.
Do you happen to know what causes this?