Unable to load data into a table using the LOAD DATA statement (w/ a tab delimited file)

Asked Jun 06 '19 at 20:56

Active Jun 07 '19 at 02:11

Viewed 46 times

I'm attempting to load a tab delimited file into my dataset by the following script:

LOAD DATA INFILE 'C:\ProgramData\MySQL\MySQL Server 8.0\Uploads\host_table_airbnb_new.txt'
INTO TABLE host;

SHOW VARIABLES 
LIKE "secure_file_priv";

But I'm getting an error as

Error Code: 1290 "secure_file_priv" is on.

I believe that my syntax is correct and my file is located in the correct prescribed location, but by some reason I cannot load my data.

Could you please help me to understand what and where I am doing wrong? Thanks.

edited Jun 07 '19 at 02:11

Kate Orlova

asked Jun 06 '19 at 20:56

clintondsm

You should remember to use \\ (double backslash) in windows paths: 'C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Uploads\\host_table_airbnb_new.txt' – fifonik Jun 06 '19 at 21:21
the double backslash worked! thanks for the help – clintondsm Jun 07 '19 at 14:44

0 Answers0