Can't find file: './mysql/plugin.frm' (errno: 13)[mysql数据目录迁移错位]错误解决
来源:互联网 发布:windows上安装jenkins 编辑:程序博客网 时间:2024/06/07 08:17
大概需要4个步骤,其中第1步通过service mysql stop停止数据库,第4步通过service mysql start启动数据库。
第2步移动数据文件,不知道是否为Ubuntu智能的原因,移动数据库的时候,除了数据文件,连权限也一起带过去了
root@T60:~#mv /var/lib/mysql /home/
我还在记录/var/lib/mysql各目录的权限,当mv完成之后,/home/下面的权限保留原来/var/lib/mysql的各类权限,其中有目录,文件等等,连chown,chmod都给省事了。
本想这样就没事了,执行第4步一直启动不了,看日志文件/var/log/mysql/error.log的结果是
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)100803
12:36:36 [ERROR] Can't open the mysql.plugin table.
Please run mysql_upgrade to create it.100803 12:36:36
InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
刚才mv过去的权限都是对的,不存在还有什么权限的问题,到网上搜索大部分都是redhat系列的系统,其中的SElinux对ubuntu不适用,还差点真用chcon来修改所谓的安全之类的权限了
其实,在my.cnf中注释部分说明的很清楚
# * IMPORTANT# If you make changes to these settings and your system uses apparmor, you may# also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
按照说明进行第3步,注释掉原来的路径,增加新的路径,2行都要修改
root@T60:~# vi /etc/apparmor.d/usr.sbin.mysqld
# /var/lib/mysql/ r,# /var/lib/mysql/** rwk, 改为 /home/mysql/ r, /home/mysql/** rwk,
更新参数
root@T60:~# /etc/init.d/apparmor reload
* Reloading AppArmor profiles Skipping profile in /etc/apparmor.d/disable: usr.bin.firefox [ OK ]
修改完成后执行第4步root@T60:~# service mysql start
可以在日志中看见启动成功
/var/log/mysql/error.log
100803 12:53:07 InnoDB: Started; log sequence number 0 5646278
100803 12:53:07 [Note] Event Scheduler: Loaded 0 events
100803 12:53:07 [Note] /usr/sbin/mysqld: ready for connections.
Version: ’5.1.41-3ubuntu12.4-log’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 (Ubuntu)
转自《http://www.cnblogs.com/tangtianfly/archive/2012/12/28/2837403.html》
- Can't find file: './mysql/plugin.frm' (errno: 13)[mysql数据目录迁移错位]错误解决
- Can't find file: './mysql/plugin.frm' (errno: 13)[mysql数据目录迁移错位]错误解决
- /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
- Can't find file: './mysql/plugin.frm'
- Mysql ERROR 1017 (HY000): Can't find file: './db/table.frm' (errno: 13)
- Can’t find file mysql/host.frm
- MySQL的坑 Can't find file: './mysql/plugin.frm' 问题
- MySQL的坑 Can't find file: './mysql/plugin.frm' 问题
- 启动mysql报错Can't find file: './mysql/plugin.frm'
- 遇到Can\'t find file : \'./mc2db/job_list.frm\' <errno: 13>错误
- mysql Can't find file: './mysql/host.frm'
- mysql ERROR 1017 :Can't find file: '/xxx.frm'...错误的解决方法
- MySQL创建外键时错误:MySQL Error Number 1005 Can’t create table ‘XX.frm’ (errno: 150)
- Can't find file: './performance_schema/cond_instances.frm' (errno: 13 - Permission denied)
- mysql Can't open file: 'xx.frm' (errno: 24) 报错
- 错误代码: 1017 Can't find file: '.\bus\t_driver_info@ff1b.frm' (errno: 22 - Invalid argument)
- MYSQL ERRNO:#1005 - Can't create table './my_news_release_system/user.frm' (errno: 150)原因总结
- MySQL: 1006 - Can't create database '***' (errno: 13) 错误
- Windows下MySQL UTF8 编码设置(解决中文乱码)
- hibernate 自定义UUID(mysql uuid_short)
- Mac Intellij 控制台乱码解决
- JRebel 5.3.2
- jetty属性
- Can't find file: './mysql/plugin.frm' (errno: 13)[mysql数据目录迁移错位]错误解决
- Android解析JASON方式
- DOM解析XML文件
- 安装和使用memcached
- cocos2d-x-3.0rc0 项目创建
- 记忆,努力
- python数据结构与算法 8栈的应用之中缀前缀后缀
- 一些低交互蜜罐
- memcached了解及使用及命令