回忆之城
生命在于折腾
posts - 575,comments - 9,trackbacks - 0

nnobackupex 备份时遇到下述错误:

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: os_file_readdir_next_file() returned -1 in directory ./etc, crash recovery may have failed for some .ibd files!
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.
innobackupex: Error: The xtrabackup child process has died at /usr/bin/innobackupex line 2681.

问问google说可能是selinux引起的。

# getenforce  和 ls -Z  检查发现果然是和selinux有关。

生产环境,先关掉selinux,在用chcon去修改selinux文件属性,我想还是算了吧。

切换到root用户,执行备份命令,ok。

拿到备份去做恢复的时候,感觉备份文件比较小。解压一看,发现数据库没备份成功。

检查ibdata1文件权限,修改权限为660

posted on 2015-03-27 13:24 回忆之城 阅读(3473) 评论(0)  编辑 收藏 引用 所属分类: unix/linux数据库服务器配置
只有注册用户登录后才能发表评论。