I am using Data Load Infile to load content of .txt file to my table ,my query is like this ,
'LOAD DATA INFILE "' . $filepath . '" ignore INTO TABLE mytablename FIELDS
TERMINATED BY "," ENCLOSED BY \'"\' LINES TERMINATED BY "\r" IGNORE 1 LINES'
This query working in my Local windows server ,but same in not working in Unix server.
Note: Although in Unix server if I run same query through PHPmyadmin , it gives results perfectly. But it is not working when I am using it in db_query().
Can some one suggest , what thing m I missing in above query.