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 Mar 04 '19 at 18:44 — Muhammad Hamza Younas, Mar 04 '19 at 18:44
that worked for me! Thank you! – Rakonu Mar 05 '19 at 15:24 — Rakonu, Mar 05 '19 at 15:24

score 3 · Accepted Answer · answered Mar 06 '19 at 13:29

3

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

answered Mar 06 '19 at 13:29

Muhammad Hamza Younas

478
1
7
16

MySQL Error 29. SQL not using correct file path

1 Answers1

Linked