mysql是否支持innodb的存储类型问题

longxibendi

线上，不建议这么搞啊....
你还不如，先添加个从库，从库用innodb，然后主从切换。这么搞风险好大。

ha00012

谢谢，再安装个实例。将数据迁移。。

ha00012

安装两个实例 A、B。A实例支持innodb引擎  B实例不支持innodb引擎。启动A实例数据目录指向B的数据目录。
在启动时报innodb无法注册 [Note] Plugin 'FEDERATED' is disabled.
[Note] Plugin 'ndbcluster' is disabled.
[ERROR] Function 'INNODB' already exists
[Warning] Couldn't load plugin named 'INNODB' with soname 'ha_innodb.so'.
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] Unknown/unsupported table type: innodb
[ERROR] Aborting

如何解决？