1
回答
linux mysql into file报没有权限错误
注册华为云得mate10,2.9折抢先购!>>>   

求教在unbutu系统中执行

select * from test.person  where createTime=20150620 INTO OUTFILE '/mysql/person.txt'  FIELDS TERMINATED BY ',' ;

报如下错误

Translating SQLException with SQL state 'HY000', error code '1', message 

[Can't create/write to file '/mysql/person.txt' (Errcode: 13)];
 SQL was [select * from test.person  where createTime=20150620 INTO OUTFILE '/mysql/person.txt'  FIELDS TERMINATED BY ',' ;] for task [StatementCallback]

且已给/person目录赋予权限就是这个错,但into outfile /var/lib/mysql/就可以成功导出文件

求大神帮助 谢谢

举报
顶部