root/bin/publish_analytical_db @ 6626
1 | 6471 | aaronmk | #!/bin/sh
|
---|---|---|---|
2 | # Publishes analytical DB to nimoy
|
||
3 | # Usage: self analytical_aggregate.csv
|
||
4 | |||
5 | 6491 | aaronmk | mysql --password --database=bien3_adb <<EOF |
6 | 6474 | aaronmk | LOAD DATA LOCAL INFILE '$1' |
7 | INTO TABLE analytical_aggregate
|
||
8 | FIELDS TERMINATED BY ','
|
||
9 | OPTIONALLY ENCLOSED BY '"'
|
||
10 | ESCAPED BY '"'
|
||
11 | IGNORE 1 LINES
|
||
12 | ;
|
||
13 | EOF
|