Re: Secure File Privilege
the secure_file_priv variable is read only, can only be changed via the my.ini file.
see the following for latest testing
Local server, local client:
secure file priv: default server 8.0 folder
connection options:
opt_local_infile=1 -- this does not set the local_infile var on start up.
local_infile=1 -- set manually
OS login: admin rights
Server permissions: all
export to default folder works.
cannot import with LOAD DATA INFILE from default folder: server is running with secure file
priv option.
Local server, local client:
secure file priv: my document folder
connection options:
opt_local_infile=1 -- this does not set the local_infile var on start up.
local_infile=1 -- set manually
OS login: admin rights
Server permissions: all
export to default folder does not work.
cannot create/write to file...permission denied.
set secure file priv to "".
load local infile:
Here is where it looks for files now:
C:\ProgramData\MySQL\MySQL Server 8.0\Data\inv
Current Error: data too long for column... col is varchar(100)
import data sample:
(I removed the header, thinking that was the cause...)
1,"1"
2,"2"
3,"3"
4,"4"
5,"5"
6,"6"
7,"7"
8,"8"
9,"9"
Code:
LOAD DATA INFILE 'aisle.csv'
INTO TABLE aisle
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;