Issue LOAD DATA LOCAL INFILE is forbidden - Plesk 18

[Peter_R]

Hello i have a script that purges a MariaDB and Update with new date on daily basis.


However when executing i get following error:


" LOAD DATA LOCAL INFILE is forbidden, check mysqli.allow_local_infile "


I looked everywhere and very little info out there.


i modified

/etc/my.cnf.d

to

local-infile=1


rebooted


Nothing Helps


Please advise on how to enable Local Infile in Plesk 18 Linux.


please help

Thanks

 

[IgorG]

Maybe this article will help you OpenEMR External Data Load Query Error - mi-squared

 

[andyxyz]

php -i | grep mysqli.allow_local_infile
mysqli.allow_local_infile => Off => Off

should be

php -i | grep mysqli.allow_local_infile
mysqli.allow_local_infile => On => On

edit your CLI php.ini accordingly

(took me most of the day to figure this out.. the web scipts were all showing mysqli.allow_local_infile => On => On but somehow the cli was coming into play)