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
编辑/etc/my.cnf,添加
[mysqld]
innodb_force_recovery=1
重启数据库服务
启动成功后,在去掉该条记录,再次重启数据库服务,即可。
可参看:http://www.softaculous.com/board/index.php?tid=4700&title=MySQL_not_starting