Displaying 1 result from an estimated 1 matches for "nofielddelims".
2004 Jun 02
0
Script to import Master.csv in the MySQL database - a short HowTo
...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 VIM script (nofielddelims.vim) for this purpose
ex /var/log/asterisk/cdr-csv/Master.csv.mod -c ":source
nofielddelims.vim" -c ":exit"
# run the MySQL commands from the cmd.sql file
mysql < cmd.sql
2. Enter the command to make the script executable:
chmod 755 impcdr2sql
3. Create a file named 'n...