Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I have run this to enable local infile:
SHOW GLOBAL VARIABLES LIKE 'local_infile';
SET GLOBAL local_infile = 'ON';
SHOW GLOBAL VARIABLES LIKE 'local_infile';
And indeed after that the local infile in on, but when I try loading file again, I still get notification, saying that my file does not exist.
Can someone tell me what should be done ?
If you already enabled LOAD DATA INFILE and verified its SET to ON, most likely the command you are using or the path you specify for the text file might be wrong.
The command would be mysql> LOAD DATA LOCAL INFILE '/path/filename.txt' INTO TABLE tablename;
Refer to Load Data Infile.
