help on permission issue - mysql select INTO OUTFILE

[dandumit]

HEllo all,
I am trying to run a script for table migration and this uses a mysql function INTO OUTFILE. I get this error :

MySQL error 1: Can't create/write to file '/home/admin/domains/arax.ro/public_html/admin045ur9jez/preztoolz/copy_shopdata_accessory.dtx' (Errcode: 13 "Permission denied")
Generated by URL '/admin045ur9jez/preztoolz/copy_shopdata.php'
with Query 'SELECT `id_product_1`,`id_product_2` INTO OUTFILE '/home/admin/domains/arax.ro/public_html/admin045ur9jez/preztoolz/copy_shopdata_accessory.dtx' FROM `ps_accessory`'

I have tried to change folder permissions / owner :

[root@host1 /]# chmod 755 /home/admin/domains/arax.ro/public_html/admin045ur9jez/preztoolz/
[root@host1 /]# chown mysql:mysql /home/admin/domains/arax.ro/public_html/admin045ur9jez/preztoolz/

but doesn't work. Any ideeas please ?

thank you,
Daniel

 

[Zhenyapan]

try chown to admin, or check who runs your scripts system(id);
al least set 777 to this folder just for test

 

[dandumit]

@Zhenyapan - thanks for hints. php scripts are run under php-fpm. I have made chown to admin.admin and 777. still no luck...

 

[Zhenyapan]

disable_functions?