1
回答
linux mysql into file报没有权限错误
开发十年,就只剩下这套Java开发体系了   

求教在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/就可以成功导出文件

求大神帮助 谢谢

举报
顶部