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

最新推荐文章于 2021-04-20 16:13:50 发布

weixin_39611070

最新推荐文章于 2021-04-20 16:13:50 发布

阅读量113

点赞数

文章标签： mysql ibdata1 mode

本文链接：https://blog.csdn.net/weixin_39611070/article/details/113907701

版权

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/mysqlrm -rf ib_logfile0 ib_logfile1

3、重新启动mysql

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

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

weixin_39611070

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

mysql的cpu高定位

网易搬砖选手

05-13

339

导致数据库CPU很高的原因有很多种，一般和慢SQL也有关（因为每条SQL要么占CPU高，要么占IO高，大体是这样）。（1）、如果服务器有多个mysql实例，需要通过top命令看看是哪个my...

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

weixin_34402408的博客

03-24

361

mysql数据库服务无法启动，查看日志报错如下：2015-01-07 17:48:54 9136 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode2015-01-07 17:48:54 9136 [ERROR] InnoDB: The system tablespace must be writable!...

参与评论您还未登录，请先登录后发表或查看评论

MYSQL服务无法启动：InnoDB: .\ibdata1 can‘t be opened in read-write mode

Beginner_G的博客

04-20

876

今天启动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 f

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

weixin_42394573的博客

01-18

370

最近开始研究mysql，有一台服务器，第一次部署时有一些配置文件的路径有问题，打算重新部署，因为mysql用的二进制安装方式，删除了mysql目录，重新部署是报错：# ./scripts/mysql_install_db --defaults-file=/etc/my.cnf --user=mysqlInstalling MySQL system tables...2015-05-29 11:1...

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

ckumtg3452的博客

01-25

363

问题： [root@localhost mysql]# ./scripts/mysql_install_db --user=mysql --basedir=/u01/app/mysql --datadir=/u01/app/m...

MySql启动错误1067之 InnoDB: .\ibdata1 can't be opened in read-write mode

小划乐的博客

08-30

3828

免安装版MySql，启动服务一直提示错误1067 多方百度，查看windows系统日志错误信息: InnoDB: .\ibdata1 can't be opened in read-write mode 继续百度解决方法： 1、打开任务管理器终止mysqld进程； 2、打开mysql安装目录的data文件夹，删除以下2个文件： ib_logfile0和ib_logfile1...

[ERROR] InnoDB: /opt/lampp/var/data/ibdata1 can't be opened in read-write mode

jing_flower的博客

02-25

968

恢复后修改文件夹权限： chown -R mysql.mysql data 备份恢复后启动数据库 /opt/lampp/sbin/mysqld --defaults-file=/opt/lampp/etc/my.cnf --user=root & 2018-04-16 17:32:31 140001994162432 [Note] InnoDB: Using mutexes ...

MySQL安装方式（5.7版本和8.0版本）

zt_96123的博客

04-10

1784

一、rpm安装mysql 1.首先检查机器里是否已经存在MySQL [root@localhost ~]# rpm -qa | grep mysql mysql-community-server-5.7.14-1.el7.x86_64 mysql-community-libs-5.7.14-1.el7.x86_64 mysql-community-common-5.7.14-1.el7.x86_6...

服务器突然断电，重启后找不到mysql.sock文件、innodb引擎表（日志表）损坏

weixin_43194701的博客

05-27

706

服务器突然断电，重启后找不到mysql.sock文件、innodb引擎表（日志表）损坏一. 1.mysql启动报错 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) 2.检查mysqld状态（数据出现损坏）：连接失败！ 2015-01-07 17:48:54 9136 [ERROR] InnoDB: .\ibdata1 can't be opened in read-

linux 下安装mysql

qq_40584095的博客

01-11

238

1. 下载mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz的安装包 https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz 一般我是用迅雷下载，稍微快一点 2. 使用xshell上传压缩包到linux系统下 3.Linux 系统下查询是否有...

MYSQL服务无法启动：InnoDB: .\ibdata1 can't be opened in read-write mode

菜鸟攻城师的一亩三分地

02-16

1999

在一台window server 2008 64，安装了两个mysql服务，第一个mysql安装时正常的安装方法，第二个的安装时通过第一已安装好的mysql所有文件复制，在mysqld -install myql2命令安装的，服务是安装成功了，但是mysql2服务启动不了（但是系统进程中有mysql2的进程），看了下系统日志，居然有很多报错，贴个图哈主要错误有： InnoDB:

mysql ibdata1 mode_MySql：InnoDB: .\ibdata1 can't be opened in read-write mode

weixin_35789885的博客

02-07

383

场景还原：1.厂商A正常安装MySql5.6，占用端口33062.我方正常安装MariaDB，占用端口83063.服务器部署完成后，检测正常(未注意到A厂服务，不确定是否造成冲突，任务管理器两个mysqld均正常)4.隔天A厂操作了一把，然后发现MariaDB服务宕机，加上服务后，提示和事件检查器显示如下：服务启动提示：1067 进程意外终止事件启动器提示：InnoDB: .\ibdata1 ca...

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

cuanwuqian6695的博客

05-29

692

最近开始研究mysql，有一台服务器，第一次部署时有一些配置文件的路径有问题，打算重新部署，因为mysql用的二进制安装方式，删除了mysql目录，重新部署是报错： # ./scripts/mysql_install_db...

mysql ibdata1 mode_MYSQL服务无法启动：InnoDB: .\ibdata1 can't be opened in read-write mode

weixin_26833139的博客

01-18

实验倒腾mysql数据库，后来发现服务无法启动，查看日志报错如下：2015-01-07 17:48:54 9136 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode2015-01-07 17:48:54 9136 [ERROR] InnoDB: The system tablespace must be writable!20...

Mysql报错无法启动：[ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode

七色花

05-08

414

打开任务管理器，关闭mysql进程，重启mysql即可原文地址

mysql 5.6 ibdata1,解决mysql 5.6 的 ./ibdata1 can't be opened in read-write mode问题

weixin_39556853的博客

03-17

183

2015-08-19 01:12:31 6608 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode2015-08-19 01:12:31 6608 [ERROR] InnoDB: The system tablespace must be writable!2015-08-19 01:12:31 6608 [ERROR] Pl...

windows mysql 启动报1067错误 .\ibdata1 can't be opened in read-write mode

w123456woaini的博客

05-15

541

1、错误提示如下： 2019-05-15 10:39:26 8204 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode 2019-05-15 10:39:26 8204 [ERROR] InnoDB: The system tablespace must be writable! 2019-05-15 10:39:26 82...

mysql ibdata1 mode_解决mysql 5.6 的 ./ibdata1 can't be opened in read-write mode问题

weixin_29738537的博客

01-18

187

mysql error 11_mysql Unable to lock ./ibdata1, error: 11