Problem With Loading txt File in mySql 5.6 Command Line Client
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.