首页 > 数据库技术 > 详细

[ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode

时间:2016-03-24 16:38:42      阅读:2239      评论:0      收藏:0      [点我收藏+]

mysql数据库服务无法启动,查看日志报错如下:


2015-01-07 17:48:54 9136 [ERROR] InnoDB: .\ibdata1 can‘t be opened in read-write mode
2015-01-07 17:48:54 9136 [ERROR] InnoDB: The system tablespace must be writable!
2015-01-07 17:48:54 9136 [ERROR] Plugin ‘InnoDB‘ init function returned error.
2015-01-07 17:48:54 9136 [ERROR] Plugin ‘InnoDB‘ registration as a STORAGE ENGINE failed.
2015-01-07 17:48:54 9136 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-01-07 17:48:54 9136 [ERROR] Aborting


解决方法:

1、kill  mysql进程;

2、cd /data/mysql 

rm -rf ib_logfile0 ib_logfile1




3、重新启动mysql



[ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode

原文:http://aroma.blog.51cto.com/11254807/1754739

(1)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!