Hello,
I was running MySQL 5.5 and I was able to export results of MySQL queries into a file using "INTO OUTFILE". Everything was fine.
Then I updated to MySQL 5.6 last days (for some reasons) and now, when I run the same queries, it gives me the error : "Can't create/write to file '/home/account/dir/dir2/filename.csv' (Errcode: 13 - Permission denied)".
I tried using "INTO OUTFILE 'filename.csv'" instead of "INTO OUTFILE '/home/account/dir/dir2/filename.csv'" and it worked ! But I can't understand the problem since dir2 has 777 permissions...
What's the problem now ?? Why MySQL is unable to write this file ??
Thanks in advance for your help,
T.
I was running MySQL 5.5 and I was able to export results of MySQL queries into a file using "INTO OUTFILE". Everything was fine.
Then I updated to MySQL 5.6 last days (for some reasons) and now, when I run the same queries, it gives me the error : "Can't create/write to file '/home/account/dir/dir2/filename.csv' (Errcode: 13 - Permission denied)".
I tried using "INTO OUTFILE 'filename.csv'" instead of "INTO OUTFILE '/home/account/dir/dir2/filename.csv'" and it worked ! But I can't understand the problem since dir2 has 777 permissions...
What's the problem now ?? Why MySQL is unable to write this file ??
Thanks in advance for your help,
T.
Last edited: