Problem With Loading txt File in mySql 5.6 Command Line Client 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&gt; LOAD DATA LOCAL INFILE '/path/filename.txt' INTO TABLE tablename;


Refer to Load Data Infile.