Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
Problem Description
We can use LOAD DATA LOCAL INFILE with the CLI however it looks like this command has been disabled by MaxScale.
It would be more convenient to have this enable so that we can use the GUI to import CSV or JSON data into the table.
Design
The REST-API should expose some endpoint that hooks up to mysql_set_local_infile_handler to which the GUI then streams the data. The data itself doesn't have to contain complete lines and can be (?) just raw chunks of the data.
One potential method for this would be to use the existing WebSocket mechanism and read the data from there.
A simpler approach would be to have a normal HTTP POST endpoint to which the data file is uploaded to.