mysql 启动不了 innodb的 一启动就报错的解决方法

120717 20:07:18 [Note] Plugin 'FEDERATED' is disabled.
120717 20:07:18  InnoDB: Initializing buffer pool, size = 512.0M
120717 20:07:19  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 134217728 bytes!
120717 20:07:19 [ERROR] Plugin 'InnoDB' init function returned error.
120717 20:07:19 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120717 20:07:19 [ERROR] Unknown/unsupported table type: InnoDB
120717 20:07:19 [ERROR] Aborting

 

日志如上

 

首先要备份下你的数据  我不懂php了 整个mysql都拷贝了一下 然后 改数据引擎在my,ini中

 

default-storage-engine = InnoDB

 

发现就是这个

 

然后改缓存

innodb_log_file_size=5M

注意这个5m 和我错误日志的大小一致  然后重启mysql  一切ok

记得要备份 一定要备份！

 

转载于:https://www.cnblogs.com/zcm123/archive/2012/07/17/2595802.html