MYSQL服务无法启动:InnoDB: .\ibdata1 can't be opened in read-write mode
来源:互联网 发布:js img中心不停的旋转 编辑:程序博客网 时间:2024/06/05 01:15
在一台window server 2008 64,安装了两个mysql服务,
第一个mysql安装时正常的安装方法,第二个的安装时通过第一已安装好的mysql所有文件复制,在mysqld -install myql2命令安装的,服务是安装成功了,但是mysql2服务启动不了(但是系统进程中有mysql2的进程),看了下系统日志,居然有很多报错,贴个图哈
主要错误有:
InnoDB: .\ibdata1 can't be opened in read-write mode
InnoDB: The system tablespace must be writable!
Plugin 'InnoDB' init function returned error.
Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Unknown/unsupported storage engine: INNODB
所以我就百度了第一句,InnoDB: .\ibdata1 can't be opened in read-write mode
解决办法:找到mysql安装目录下的data文件夹,有两个文件ib_logfile0和ib_logfile1,结束msql2服务进程,直接删除,然后重新启动mysql2服务就ok了,
0 0
- MYSQL服务无法启动:InnoDB: .\ibdata1 can't be opened in read-write mode
- MYSQL服务无法启动:InnoDB: .\ibdata1 can't be opened in read-write mode
- MYSQL服务无法启动:InnoDB: .\ibdata1 can't be opened in read-write mode
- Mysql ./ibdata1 can't be opened in read-write mode
- 【问题解决】MYSQL 服务无法启动,错误日志:InnoDB: .\ibdata1 must be writable
- ORA-16433: The database must be opened in read/write mode
- MYSQL启动报1067错误 MySQL服务无法启动 或者Can't create/write to file#sql6e80_1905f7_3.MYI'
- MySQL服务无法启动(2003 - Can't connect to MySQL server on‘localhost' (10061).)
- MySQL服务无法启动(2003 - Can't connect to MySQL server on‘localhost' (10061).) 解决办法
- MySQL服务无法启动(2003 - Can't connect to MySQL server on‘localhost' (10038).)
- MySQL服务无法启动(2003 - Can't connect to MySQL server on‘localhost' (10038).)
- MySQL服务无法启动(2003 - Can't connect to MySQL server on‘localhost' (10061).)
- MySQL服务无法启动(2003 - Can't connect to MySQL server on‘localhost' (10061).)
- MySQL 服务无法启动 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- mysql服务已经启动但是无法进行连接(can't connect to mysql 1055)
- mysql启动报错Can't read from messagefile处理
- SVN无法提交 Can't set file "/db/txn_current" read-write :拒绝访问
- MYSQL:Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
- Java-强引用、软引用、弱引用、虚引用详解
- C#泛型总结
- jmeter测试http接口
- java.lang.UnsatisfiedLinkError: D:\Tomcat\apache-tomcat-7.0.37\bin\tcnative-1.dll: Can't load AMD 6
- linux抓包工具的学习
- MYSQL服务无法启动:InnoDB: .\ibdata1 can't be opened in read-write mode
- UITextView 实现placeholder的方法
- 观察者模式
- 移动前端开发知识资源整理
- httpclient解析https网页
- 关于Handler的拦截
- Webshell-Part1&Part2
- 深入了解jBPM5与Activiti之间的差异对比
- shadowsocks