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]
Recent Comments