Asterisk CDR csv conversion mysql

  • by

LOAD DATA INFILE '/var/log/asterisk/cdr-csv/Master.csv'
INTO TABLE cdrnew
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
(accountcode, src,dst, dcontext, clid, channel, dstchannel, lastapp, lastdata, calldate, answertime, endtime, duration, billsec, disposition, amaflags, uniqueid,any_comumnname);

Leave a Reply

Your email address will not be published. Required fields are marked *