mysqldump: Got error: 1: Can't create/write to file '/data/export/test.txt' (Errcode: 13)
来源:互联网 发布:淘宝棋牌游戏源码 编辑:程序博客网 时间:2024/05/18 12:36
问题
需要将数据已csv格式导出到/data/export/路径下,遇到问题:
mysqldump: Got error: 1: Can’t create/write to file ‘/data/export/test.txt’ (Errcode: 13) when executing ‘SELECT INTO OUTFILE’
分析
环境
OS: Ubuntu 14.04 LTS
MySQL: 5.6.x #datadir=/data/mysql
通过mysqldump -T 导出的数据是两个文件,数据表结构我test.sql,数据文件为test.txt。导出过程中,test.sql创建成功了,但是test.txt文件提示不能写入,实际也没有创建。
于是,检查权限,将/data/export修改为mysql:mysql还是报错。
这是因为ubuntu安全机制的原故。apparmor对于mysqld默认没有配置路径/data/export/的访问权限。这个导出,test.sql是mysqldump来完成的,成功创建,但是,test.txt是通过mysqld的select into outfile来完成,所以因为没有权限,无法创建。
解决方案
修改/etc/apparmor.d/mysqld
vim /etc/apparmor.d/mysqld增加
/data/export/** rw,重新载入配置
/etc/init.d/apparmor reload再次导出即可。
Wait for your reward
0 0
- mysqldump: Got error: 1: Can't create/write to file '/data/export/test.txt' (Errcode: 13)
- mysqldump: Got error: 1: Can't create/write to file '/usr/local/mysql/data/bak/t4.txt' (Errcode: 13
- mysqldump: Got error: 1: Can't create/write to file (Errcode: 13
- ERROR 1 (HY000): Can't create/write to file '/test.txt' (Errcode: 13)
- ERROR 1 (HY000): Can't create/write to file '/myload/user6.txt' (Errcode: 13
- ERROR 1 (HY000): Can't create/write to file'/' (Errcode: 13)错误解决
- ERROR 1 (HY000): Can't create/write to file'/' (Errcode: 13)错误解决
- ERROR 1 (HY000): Can't create/write to file'/' (Errcode: 13)错误解决
- mysqldump 备份命令错误 Can't create/write to file '' (Errcode: 13)
- /usr/libexec/mysqld: Can’t create/write to file ‘/tmp/’ (Errcode: 13)
- MySQL下“Can’t create/write to file xxx (Errcode: 13)”错误的解决方法
- Can't create/write to file '/tmp/#sql_909_0.MYI' (Errcode: 13)
- [hive]Can't create/write to file '/tmp/#sql_2290_0.MYI' (Errcode: 13)
- MySQL下“Can’t create/write to file xxx (Errcode: 13)”错误的解决方法
- MySQL下“Can’t create/write to file xxx (Errcode: 13)”错误的解决方法
- 解决:CentOS下MySQL执行select ... into outfile ...: Can't create/write to file '...' (Errcode: 13)
- Mysql ERROR 1 (HY000): Can't create/write to file
- Mysql [ERROR] /usr/sbin/mysqld: Can't create/write to file '/xxx/mysqld/mysql.pid' (Errcode: 2) 处理
- 多层json解析
- Http,Https (SSL)的Url绝对路径,相对路径解决方案Security Switch 4.2 中文帮助文档
- android 操作数据库
- LeetCode/reverse(地址A,地址B)的使用和表示的反转范围
- 6.7.4 qmgr_message_assign函数:创建QMGR_JOB、QMGR_PEER、QMGR_ENTRY结构体
- mysqldump: Got error: 1: Can't create/write to file '/data/export/test.txt' (Errcode: 13)
- Java Map遍历
- Shake动画实现
- ios上的数据持久化问题概览(Data Persistence On iOS – An Overview)
- UIView的contentMode使用小结
- Self Summary: Ruby flat scope programming and meta-programming
- Windows环境下安装Elasticsearch
- 工作中一个管理者的态度
- Android 学习记录-ListView动态布局内容