I'm not certain, but it doesn't look to me as a MySQL version issue. It's more
probably a umask issue. Search for "umask" and you'll probably find the answer.
However, it's likely that this is suboptimal and risky. It would probably be
better to run `mysql` (or whatever mysql client you are using) as the same
operating system user as the one who will read and write the csv file later.
Regards,
Antonis
Antonis Christofides
+30-6979924665 (mobile)
On 18/03/2022 06.48, Aadil Rashid wrote:
When I run this query on mysql 5.7:
SELECT CURDATE() INTO OUTFILE '/var/lib/mysql-files/test.csv';
It creates test.csv with the following permissions:
-rw-rw-rw- 1 mysql mysql 11 Mar 18 04:27 test.csv
But when I create the same file in mysql 8.0 it creates file with the
following permissions:
-rw-r----- 1 mysql mysql 11 Mar 18 09:54 test.csv
How would I allow mysql 8 to create file with the same permissions it created
with mysql 5.7 ? The reason being I need to read and write to that generated
file later in my application.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/5292768f-f3f4-4973-aea2-ecceb1cda299n%40googlegroups.com
<https://groups.google.com/d/msgid/django-users/5292768f-f3f4-4973-aea2-ecceb1cda299n%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
You received this message because you are subscribed to the Google Groups "Django
users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/c5824464-a427-d8fc-ae3b-a4391db69830%40antonischristofides.com.
