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

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

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

Postby fedebais » 09. September 2019 13:27

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"
fedebais
 
Posts: 1
Joined: 09. September 2019 01:13
XAMPP version: 7.3.1
Operating System: MAC OS

Return to XAMPP for Mac OS X

Who is online

Users browsing this forum: No registered users and 3 guests