UNIX上Mysql中的错误代码13.谁能帮我? [英] Error Code 13 in Mysql on UNIX. Can anyone Help me?

问题描述

我正在UNIX系统上使用MySQL Server，

I'm Using MySQL Server on UNIX System,

当我执行以下查询时

SELECT * INTO '/home/krunal/backupData/myBackup1.txt' FROM tbl_Property;

它显示错误

错误1(HY000):无法创建/Write to file>'/home/krunal/backupData/myBackup1.txt'(错误代码:13)

ERROR 1 (HY000): Can't Create /Write to file >'/home/krunal/backupData/myBackup1.txt' (Errorcode : 13)

谁能告诉我如何解决此错误

Can anyone tell me that how can i solve this error

**Note**:我具有dir backupData，Read，Write，Execute的所有权限

**Note** : I have all the permission on dir backupData , Read , Write , Execute

推荐答案

您搞砸了/home/krunal/backupData/权限.要解决:

You messed up with /home/krunal/backupData/ permissions. To fix:

  chown root:root /home/krunal/backupData/
  chmod 1777 /home/krunal/backupData/
  /etc/init.d/mysqld restart

来源: 查看全文