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

原创 2018年04月16日 17:39:01

恢复后修改文件夹权限:

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 to ref count buffer pool pages
2018-04-16 17:32:31 140001994162432 [Note] InnoDB: The InnoDB memory heap is disabled
2018-04-16 17:32:31 140001994162432 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-04-16 17:32:31 140001994162432 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-04-16 17:32:31 140001994162432 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-04-16 17:32:31 140001994162432 [Note] InnoDB: Using SSE crc32 instructions
2018-04-16 17:32:31 140001994162432 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-04-16 17:32:31 140001994162432 [Note] InnoDB: Completed initialization of buffer pool
2018-04-16 17:32:31 140001994162432 [ERROR] InnoDB: /opt/lampp/var/data/ibdata1 can't be opened in read-write mode
2018-04-16 17:32:31 140001994162432 [ERROR] InnoDB: The system tablespace must be writable!
2018-04-16 17:32:31 140001994162432 [ERROR] Plugin 'InnoDB' init function returned error.
2018-04-16 17:32:31 140001994162432 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-04-16 17:32:31 140001994162432 [Note] Plugin 'FEEDBACK' is disabled.
2018-04-16 17:32:31 140001994162432 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2018-04-16 17:32:31 140001994162432 [ERROR] Unknown/unsupported storage engine: InnoDB

2018-04-16 17:32:31 140001994162432 [ERROR] Aborting

按照网上的办法:删除rm -rf ib_logfile*

依然起不来

查看了一下文件权限:

[root@localhost data]# ls -lrt
total 75824
-rw-r-----. 1 root  root  77594624 Apr 16 17:07 ibdata1
drwx------. 2 root  root      4096 Apr 16 17:07 sakila
drwx------. 2 root  root      4096 Apr 16 17:07 mysql
-rw-r-----. 1 root  root       481 Apr 16 17:07 xtrabackup_info
drwx------. 2 root  root      4096 Apr 16 17:07 phpmyadmin
drwx------. 2 root  root      4096 Apr 16 17:07 test
drwx------. 2 root  root      4096 Apr 16 17:07 performance_schema
drwx------. 2 root  root      4096 Apr 16 17:07 userdb
-rw-rw----. 1 mysql mysql        0 Apr 16 17:18 mysql-bin.index
-rw-rw----. 1 mysql mysql       52 Apr 16 17:32 aria_log_control

-rw-rw----. 1 mysql mysql    16384 Apr 16 17:32 aria_log.00000001

修改文件权限,解决

[root@localhost data]# chown -R mysql.mysql ./*


启动mysql命令:

/opt/lampp/sbin/mysqld --defaults-file=/opt/lampp/etc/my.cnf --user=root &

/bin/sh /opt/lampp/bin/mysqld_safe  --defaults-file=/opt/lampp/etc/my.cnf --user=root &

停止mysql命令:

[root@localhost data]# mysqladmin -u root -p shutdown
Enter password: 
2018-04-16 17:46:22 140285376654080 [Note] /opt/lampp/sbin/mysqld: Normal shutdown


2018-04-16 17:46:22 140285376654080 [Note] Event Scheduler: Purging the queue. 0 events
2018-04-16 17:46:22 140285082322688 [Note] InnoDB: FTS optimize thread exiting.
2018-04-16 17:46:22 140285376654080 [Note] InnoDB: Starting shutdown...
2018-04-16 17:46:23 140285376654080 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2018-04-16 17:46:24 140285376654080 [Note] InnoDB: Shutdown completed; log sequence number 42196502

2018-04-16 17:46:24 140285376654080 [Note] /opt/lampp/sbin/mysqld: Shutdown complete



[1]+  Done                    /opt/lampp/sbin/mysqld --defaults-file=/opt/lampp/etc/my.cnf --user=root


登陆命令:

[root@localhost data]# /opt/lampp/bin/mysql -uroot -p
Enter password: 


版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/jing_flower/article/details/79963757

深入Javascript 异常(Error)视频课程

实践项目之深入Javascript 异常(Error) 课程详细的讲解了Javascript的错误异常, 深入异常的原型方法, 合理的处理自己的错误信息, 以及自定义自己的异常等等.
  • 2017年02月26日 13:08

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

今天在那做实验倒腾mysql数据库,后来发现服务无法启动,查看日志报错如下: 2015-01-07 17:48:54 9136 [ERROR] InnoDB: .\ibdata1 can't...
  • IndexMan
  • IndexMan
  • 2015-01-07 18:18:40
  • 29209

Mysql ./ibdata1 can't be opened in read-write mode

服务器: Window Server 2012进入Mysql时出现如下问题ERROR 1045 (28000): Access denied for user 'xxx'@'localhost' (u...
  • u011707236
  • u011707236
  • 2016-06-28 09:34:57
  • 2120

MySQL 服务无法启动 1067错误

安装mysql-5.6.13-winx64完成后,net start mysql 启动时报错。   查看错误信息:  2013-08-20 09:52:28 2520 [Note] Plugin ...
  • hbxtw
  • hbxtw
  • 2013-08-20 10:26:18
  • 10647

xampp安装、问题解决及使用

转载自:http://mp.weixin.qq.com/s?__biz=MzIxNjYwMzc1MQ==&mid=2247483658&idx=1&sn=47fb376247329718fae0b92...
  • qq_36652619
  • qq_36652619
  • 2017-10-21 19:39:55
  • 147

nnoDB: ./ib_logfile0 can't be opened in read-write mode

报错日志:在使用innobackup 远程备份后,apply log 时遇到的报错2018-02-28 18:21:41 26721 [Note] InnoDB: Completed initiali...
  • royjj
  • royjj
  • 2018-03-01 22:23:58
  • 53

innodb_read_only 和read_only

innodb_read_only 启动server 在read-only模式。对于分布在数据库应用或者数据设置为只读介质。 也可以用于数据仓库共享相同的数据目录在多个实例之间。 read_onl...
  • zhaoyangjian724
  • zhaoyangjian724
  • 2015-11-18 13:49:34
  • 1729

InnoDB: Error in opening ./ibdata1 问题重现

今日由于需要重启线上服务器,当SA跟我说他那边已经OK 的时候,我便开始重启mysql:/usr/local/mysql/bin/mysqld_safe --user=mysql &  但是看了下m...
  • qiuyepiaoling
  • qiuyepiaoling
  • 2012-04-12 15:21:56
  • 2310

mysql Unable to lock ./ibdata1, error: 11

重启linux服务器,发现mysql没能起来,使用service mysql start,程序一直处于---状态。查看mysql日志(一般在var/lib/mysq.err),发现Unable to ...
  • u012072012
  • u012072012
  • 2015-04-28 11:39:34
  • 2802

CentOs6.7环境下rpm包安装mysql5.7

CentOs6.7环境下rpm包安装mysql5.7
  • caicongyang
  • caicongyang
  • 2016-01-31 15:30:25
  • 5004
收藏助手
不良信息举报
您举报文章:[ERROR] InnoDB: /opt/lampp/var/data/ibdata1 can't be opened in read-write mode
举报原因:
原因补充:

(最多只允许输入30个字)