Load Data In file MySQL MacOS

Question

I'm trying to load data from a CSV using MySQL, but I'm getting Error code 29 (file not found). I'm using mac osx, but when I run the following query

LOAD DATA INFILE '/workspace/SQL_Test/src/values.csv' 
INTO TABLE queryid_vs_column
COLUMNS TERMINATED BY ','

MySQL tries to look in 'C:/workspace/SQL_Test/src/values.csv'. I haven't found anyone else with similar issues, has anyone encountered something like this? I'm not sure why MySQL thinks I'm running a windows machine.

Thanks.

Is the MySQL server running on the Mac? LOAD DATA INFILE accesses files on the server, not the client. — Barmar
– Barmar, Commented Sep 21, 2013 at 17:52
Ahh okay, so does that mean LOAD DATA LOCAL accesses the client? @Barmar — Nick Nicolini
– Nick Nicolini, Commented Sep 21, 2013 at 17:56

Barmar · Accepted Answer · 2013-09-21 17:59:10Z

5

If you don't use the LOCAL modifier, it accesses the file on the server. Change your query to:

LOAD DATA LOCAL INFILE '/workspace/SQL_Test/src/values.csv' 
INTO TABLE queryid_vs_column
COLUMNS TERMINATED BY ','

answered Sep 21, 2013 at 17:59

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nick Nicolini Over a year ago

Thank you. I see now this was a silly question, sorry for that.

Collectives™ on Stack Overflow

Load Data In file MySQL MacOS

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related