mysql 启动经典错误，大家来看看
我用innobackupex 备份文件后，然后用innobackupex 还原，先–apply-log 然后–copy-back，在还原前 先停止数据库，然后把 当前datadir里面东西都给删除。
但是在启动的时候居然报这样错误。我把ib_文件都删除， rm -rf ib_logfile* && rm -rf mysql-bin.* 还是不起作用，
这个是不是日志文件造成的，但是我的2个机器配置都是一样的，从A备份数据，然后到B还原，A B只是端口和数据库目录不一样，其他基本都是一致的。
然后我测试了一下把ibdata1 这个文件给删除，数据库可以正常启动，但是有个问题，却找不到表结构。显然问题就出在ibdata1文件上 但是这个文件不能删除。否则 .frm .ibd 就识别不了，
这个启动是什么错误？大家看看
111018 17:20:47 mysqld_safe Starting mysqld daemon with databases from /data/mysql/data3307
111018 17:20:47 [Note] Plugin ‘FEDERATED’ is disabled.
111018 17:20:48 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 256 MB
InnoDB: Database physically writes the file full: wait…
InnoDB: Progress in MB: 100 200
111018 17:20:49 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 256 MB
InnoDB: Database physically writes the file full: wait…
InnoDB: Progress in MB: 100 200
111018 17:20:51 InnoDB: Log file ./ib_logfile2 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile2 size to 256 MB
InnoDB: Database physically writes the file full: wait…
InnoDB: Progress in MB: 100 200
InnoDB: Cannot initialize created log files because
InnoDB: data files are corrupt, or new data files were
InnoDB: created when the database was started previous
InnoDB: time but the database was not shut down
InnoDB: normally after that.
111018 17:20:52 [ERROR] Plugin ‘InnoDB’ init function returned error.
111018 17:20:52 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
111018 17:20:52 [ERROR] Unknown/unsupported table type: INNODB
111018 17:20:52 [ERROR] Aborting
111018 17:20:52 [Warning] Forcing shutdown of 1 plugins
111018 17:20:52 [Note] /usr/local/mysql3307/bin/mysqld: Shutdown complete
111018 17:20:52 mysqld_safe mysqld from pid file /data/mysql/data3307/szgeobetadb2.morningstar.com.pid ended
——解决方案——————–
表坏了
转载请注明原文链接：mysql 启动经典异常，大家来看看
