Cant import large file from mysql command line on XAMPP-VM

[fedebais]

I have my XAMPP VM and i cant import file from mysql command line because i cant copy file to var directory, i cant do permission to /opt/lampp/var/mysql directory

Code: Select all

MariaDB [geosmart_hurlingham]> LOAD DATA INFILE 'path/to/file.csv' INTO TABLE parcelas FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' SET id=null;
ERROR 13 (HY000): Can't get stat of '/opt/lampp/var/mysql/path/to/file.csv' (Errcode: 2 "No such file or directory"