MySQL Error 29. SQL not using correct file path

Question

Working on using the LOAD DATE INFILE syntax to import my csv files into my database. Using windows 10.

Originally when using this syntax I was getting ERROR 1290 which I resolved by adding: secure-file-priv = "" to the .ini file.

I no longer get ERROR 1290 but when i use:

LOAD DATA INFILE 'C:\Users\ovoJa\Downloads\VEN01_562.csv'  
INTO TABLE    venom  
FIELDS TERMINATED BY ','  
ENCLOSED BY '"' 
LINES TERMINATED BY '\n'

I get this ERROR 29:

File 'C:\ProgramData\MySQL\MySQL Server 8.0\Data\UsersovoJaDownloadsVEN01_562.csv' not found (OS errno 2 - No such file or directory)

Why is it still looking in the Programdata file for the .csv file?

try to use this C:\\Users\\ovoJa\\Downloads\\VEN01_562.csv

Muhammad Hamza Younas
– Muhammad Hamza Younas

2019-03-04 18:44:03 +00:00
Commented Mar 4, 2019 at 18:44 — Muhammad Hamza Younas
– Muhammad Hamza Younas, Commented Mar 4, 2019 at 18:44
that worked for me! Thank you!

Rakonu
– Rakonu

2019-03-05 15:24:41 +00:00
Commented Mar 5, 2019 at 15:24 — Rakonu
– Rakonu, Commented Mar 5, 2019 at 15:24

Muhammad Hamza Younas · Accepted Answer · 2019-03-06 13:29:03Z

3

try to use this C:\\Users\\ovoJa\\Downloads\\VEN01_562.csv

answered Mar 6, 2019 at 13:29

Muhammad Hamza Younas

5182 gold badges7 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

MySQL Error 29. SQL not using correct file path

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related