[MySQL] 找回“消失”的InnoDB引擎

mysql> show engines;
+--------------------+---------+-----------------------------------------------------------+--------------+------+------------+
| Engine       | Support | Comment                           | Transactions | XA   | Savepoints |
+--------------------+---------+-----------------------------------------------------------+--------------+------+------------+
| MEMORY       | YES   | Hash based, stored in memory, useful for temporary tables | NO       | NO   | NO     |
| PERFORMANCE_SCHEMA | YES   | Performance Schema                    | NO       | NO   | NO     |
| MyISAM       | DEFAULT | MyISAM storage engine                   | NO       | NO   | NO     |
| CSV        | YES   | CSV storage engine                    | NO       | NO   | NO     |
| MRG_MYISAM     | YES   | Collection of identical MyISAM tables           | NO       | NO   | NO     |
+--------------------+---------+-----------------------------------------------------------+--------------+------+------------+
5 rows in set (0.01 sec)

130829  8:42:30 [Note] Slave I/O thread: connected to master 'slave@192.168.0.153:3306',replication started in log 'mysql-bin.000023' at position 232546566
130829  8:42:30 [ERROR] Slave SQL: Error executing row event: 'Unknown storage engine 'InnoDB'', Error_code: 1286
130829  8:42:30 [Warning] Slave: Unknown storage engine 'InnoDB' Error_code: 1286
130829  8:42:30 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000023' position 225856952

service mysqld stop
cd到数据目录下
mv ib_logfile* 到其他目录下
修改innodb_log_files_in_group
service mysqld start