Problem using custom query with LOAD DATA LOCAL INFILE

I’m trying to create a server action to import records quickly, using LOAD DATA LOCAL INFILE. I created a custom query but it won’t run. This is the error message:

image

I can use a separate PHP file to do this, including this line:
PDO::MYSQL_ATTR_LOCAL_INFILE => true

I don’t know if this is all that’s needed, but I imagine there isn’t a way to add options like this. It would be useful if there were.

(This is not exactly a feature request, because it may be that I’m doing something wrong, and in any case, I can use PHP to do this - though of course it would be much more convenient if it could be done within Wappler.)

Community Page
Last updated: