Currently, the file is actually loaded into the database with the MySQL-specific LOAD DATA LOCAL INFILE statement. Fallback to a row-by-row method when not MySQL. Perhaps a place fo a hook...

Comments

codexmas’s picture

codexmas commented
Version: » 6.x-1.x-dev
Category: task » feature

Aye +1 to this, LOAD DATA LOCAL INFILE is quite a security risk on shared hosting servers, anyone can read any other DB as the MySQL user.

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented
Priority: Normal » Critical

Since even some versions of MySQL don't support this, I'm changing this to critical. I will implement row-by-row import, with a "quick import" option using LOAD DATA LOCAL on MySQL (does Postgres have an equivalent).

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented
Status: Active » Needs review

Done - please try it out if you're dealing with delimited files.

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented
Status: Needs review » Fixed

So far so good - I'm marking this as fixed, if anyone has a problem importing delimited files please open a new issue.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.