Load CSV file into a table with windows/docker


#1

Hello, I’m trying to load a csv file in my computer into the memsql running in windows/docker, however I’m encountering the following error:

ERROR 1017: Can not find file… errno(2).

I’ve tried different ways of paths but the error persists
Here is an example of the load data commands I’m using:

LOAD DATA INFILE ‘/mnt/c/Users/carl0/Desktop/PMD-dados/out2.csv’
INTO TABLE empregado
COLUMNS TERMINATED BY ‘,’

LOAD DATA INFILE ‘C:\Users\carl0\Desktop\PMD-dados\out2.csv’
INTO TABLE empregado
COLUMNS TERMINATED BY ‘,’;


#2

Make sure you are using the right path, that it is a Linux path relative to your containers file space, not a windows path, and that it is readable to the memsql user that the memsql server is running as. E.g. make it world-readable like with chmod 444 filename.csv