MySQL 数据迁移启动报错 [Note] Plugin 'FEDERATED' is disabled
MySQL 数据迁移启动报错 [Note] Plugin 'FEDERATED' is disabled
错误日志内容：
170413 23:36:22 [Note] Plugin 'FEDERATED' is disabled. 170413 23:36:22 InnoDB: The InnoDB memory heap is disabled 170413 23:36:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins 170413 23:36:22 InnoDB: Compressed tables use zlib 1.2.3 170413 23:36:22 InnoDB: Using Linux native AIO 170413 23:36:22 InnoDB: Initializing buffer pool, size = 128.0M 170413 23:36:22 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 33554432 bytes! 170413 23:36:22 [ERROR] Plugin 'InnoDB' init function returned error. 170413 23:36:22 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 170413 23:36:22 [ERROR] Unknown/unsupported storage engine: InnoDB 170413 23:36:22 [ERROR] Aborting 170413 23:36:22 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
mysql data 目录下赋予mysql 账号权限
初始化数据库：
[root@iZ286290rd2Z mysql]# rm ib_logfile0 rm: remove regular file `ib_logfile0'? y [root@iZ286290rd2Z mysql]# rm ib_logfile1 rm: remove regular file `ib_logfile1'? y [root@iZ286290rd2Z mysql]# service mysqld restart ERROR! MySQL server PID file could not be found! Starting MySQL..... SUCCESS! [root@iZ286290rd2Z mysql]#
