Unable to use Upload command on machine that is running MySQL and contains file to uploau
I am trying to load some data on the machine that mysql is running on
using a load data local infile command and getting some errors. Below
are the steps and commands I have used. Please let me know how to
resolve.
CREATE TABLE `website_visits` (
`ID` int(11) NOT NULL,
`CUSTOMER_NAME` varchar(255) DEFAULT NULL,
`CUSTOMER_TYPE` int(11) DEFAULT NULL,
`DATE_STARTED` datetime DEFAULT NULL,
`DURATION` double DEFAULT NULL,
`GENDER` varchar(45) DEFAULT NULL,
`AGE` int(11) DEFAULT NULL,
`SALARY` int(11) DEFAULT NULL,
`REVIEW_DURATION` double DEFAULT NULL,
`RELATED_DURATION` double DEFAULT NULL,
`PURCHASED` int(11) DEFAULT 0,
`IS_MALE` int(11) DEFAULT NULL,
`IS_FEMALE` int(11) DEFAULT NULL,
`VIEWED_REVIEW` int(11) DEFAULT NULL,
`VIEWED_RELATED` int(11) DEFAULT NULL,
`AGE_RANGE` varchar(255) DEFAULT NULL,
`SALARY_RANGE` varchar(255) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ***********************************************************
-- Disable checks for insert of every row. This makes loading
-- really fast
-- ***********************************************************
set unique_checks = 0;
set foreign_key_checks = 0;
set sql_log_bin=0;
set autocommit = 0;
-- ***********************************************************
-- Load the csv file
-- ***********************************************************
SET GLOBAL local_infile=ON;
LOAD DATA LOCAL INFILE
"C:\ProgramData\MySQL\MySQL Server
8.0\Uploads\website_visits_data.csv"
INTO TABLE `website_visits`
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(ID, CUSTOMER_NAME, CUSTOMER_TYPE, DATE_STARTED, DURATION,
GENDER,AGE,SALARY,REVIEW_DURATION,RELATED_DURATION,PURCHASED);
Error I receive
15:45:40 LOAD DATA INFILE "C:\ProgramData\MySQL\MySQL Server
8.0\Uploads\website_visits_data.csv" INTO TABLE `website_visits`
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED
BY '\n' IGNORE 1 LINES (ID, CUSTOMER_NAME, CUSTOMER_TYPE,
DATE_STARTED, DURATION,
GENDER,AGE,SALARY,REVIEW_DURATION,RELATED_DURATION,PURCHASED)
Error Code: 1290. The MySQL server is running with the
--secure-file-priv option so it cannot execute this statement 0.000
sec
Does anybody know how to resolve this one?