Hi,
Le 30/05/2026 à 11:23, Philippe Delavalade a écrit :
Hi.
In mariadb, the command
select * from tablename into outfile '/tmp/foo.txt'
produces no file in /tmp but in a directory with a very long name:
/tmp/systemd-private-2a2439b12a22406fb9e6d8345f292014-mariadb.service-5Dg5Mh/
In this directory, I get tmp/foo.txt
I guess I have something to write in /etc/my.cnf.d/ but which lines and in
which file ?
No, this is because mariadb systemd service uses PrivateTmp, which means
that mariadb has its own /tmp, for security reasons. I do not recommend
changing this, but if you want you can look at systemd service overrides
to set PrivateTmp=no for mariadb.
Regards,
Bruno/Archange
