search for: impcdr2sql

...'cdr' table in MySQL before running the script bellow in oder to prevent dupplicate records. In my example, I have the following config: CDR database: asteriskcdrdb CDR table: cdr CVS file: /var/log/asterisk/cdr-csv/Master.csv 1. Create a file named 'impcdr2sql' with the following content: #!/bin/bash # make a copy of the original Master.csv file to Master.csv.mod cp -vf /var/log/asterisk/cdr-csv/Master.csv /var/log/asterisk/cdr-csv/Master.csv.mod # format the file to comply with the MySQL data (delete '"' chars when need it) # use a V...