ERROR 1286 (42000): Unknown storage engine 'InnoDB'
类别：win_lin_mac
post by sunshine / 2012-7-31 08:35 Tuesday
mysql>ERROR 1286 (42000): Unknown storage engine 'InnoDB'
查看错误日志
110209 12:55:44 mysqld_safe mysqld from pid file /home/mysql/mysqldir/data/localhost.localdomain.pid ended
110209 12:55:44 mysqld_safe Starting mysqld daemon with databases from /home/mysql/mysqldir/data
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
110209 12:55:44 InnoDB: Using Linux native AIO
110209 12:55:44 InnoDB: Initializing buffer pool, size = 2.0G
110209 12:55:44 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 268435456 bytes!
110209 12:55:44 [ERROR] Plugin 'InnoDB' init function returned error.
110209 12:55:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110209 12:55:45 [Note] Event Scheduler: Loaded 0 events
110209 12:55:45 [Note] /home/mysql/mysqldir/bin/mysqld: ready for connections.
Version: '5.5.8-log' socket: '/home/mysql/mysqldir/data/mysql.sock' port: 3306 Source distribution
由于实际大小和配置文件中描述的不同.因此报错.
解决：将日志文件ib_logfile0,ib_logfile1之类的文件移到别的目录.重启mysql
版权所有：《太阳花工作室》 => 《ERROR 1286 (42000): Unknown storage engine 'InnoDB'》
本文地址：http://bg.artuion.com/win_lin_mac/167.html
除非注明，文章均为 《太阳花工作室》 原创，欢迎转载！转载请注明本文地址，谢谢。