can anyone please tell me how i can provide the path of the file(from which i want to load data) in load data infile syntax.
I m using mysql on linux platform and made a querry as follows.
LOAD DATA INFILE “MyFile” INTO TABLE TB_MRR FIELDS TERMINATED BY ‘,’ IGNORE 1 LINES (NodeName, RecordId, resolution, opc, OrigRsId, origRsName, dpc, DestRsId, destRsName, finalDpc, finalRsId, finalRsName, si, gttDone, icLsId, icLsName, ogLsId, ogLsName, icNumSifOct, ogNumSifOct, icSsn, icGtDigits, icGtFrmt, icTT, ogSsn, ogGtDigits, ogGtFrmt, ogTT, isMsgSnt, msgTypeRx, msgTypeTx, svcMsgType);
executing above caommand gives the error as below.
ERROR 1105 (HY000): File ‘/var/lib/mysql/m7db/MyFile’ not found (Errcode: 2)