mysql无法启动成功 场景:系统服务器关机后,重启后无法启动。 事件服务的日志如下:
InnoDB: Attempted to open a previously opened tablespace. Previous tablespace jeeplus_schema_v1/accident_detail uses space ID: 1 at filepath: .\jeeplus_schema_v1\accident_detail.ibd. Cannot open tablespace mysql/innodb_table_stats which uses space ID: 1 at filepath: .\mysql\innodb_table_stats.ibd
解决方法:
(转)http://www.cnblogs.com/wtfbk/p/5228924.html
编辑/etc/my.cnf,添加
[mysqld]
innodb_force_recovery=
1
重启数据库服务
启动成功后,在去掉该条记录,再次重启数据库服务,即可。
可参看:http://www.softaculous.com/board/index.php?tid=4700&title=MySQL_not_starting
转载请注明原文地址: https://ju.6miu.com/read-36640.html